How to change NOW() without changing system date on the server

We run 2 'local' times on our system, for users in the 2 countries. This method works for us....

In our Application.cfc onRequestStart() we set a request variable depending on the user locale.....

if (locale2)

     request.theLocalTime = DateAdd("h",-10,Now())

else

   request.theLocalTime = Now()

/

Then, we use request.theLocalTime in place of now() throughout our .cfm pages, and pass it as an argument where needed for cfc's in the application scope.

For testing, you could simply set the request.theLocalTime variable using DateAdd(), then change it back to now() when finished.

Hope this helps

Steve

Is there a reason that the DateAdd function would not work for you? You can use it to set the various dates you might need:

<cfscript>

  current = Now();

  lastMonth = DateAdd('m',-1,current); // this would subtract one month from the current date

  nextMonth = DateAdd('m',1,current); // this would add one month from the current date

  // and so on with other dates

</cfscript>

There might be a reason why this doesn't work for you but wanted to throw it out there just in case.