Is there any "easy" way to convert GMT time out of a database to a date that will be used for linking and parameters?? I currently do this through a formula, however the reports are starting to be used overseas where I am having to do some last minute adjusting to the formula.
This is what I am currently doing:
Number of days formula:
truncate ((ToNumber ({cpsess.DATETIME}) +32400)/86400) +
Real Date formula:
date(1970,01,01) +{@number of days}
The 32400 is the number of seconds to add (this example is for Japan time adding 9 hours)
the 86400 is the number of seconds in a day
If there is a easier way to do this, I am open to any ideas. I hate having diffrent versions of the report out in the field...
Thank-You
Tonya
This is what I am currently doing:
Number of days formula:
truncate ((ToNumber ({cpsess.DATETIME}) +32400)/86400) +
Real Date formula:
date(1970,01,01) +{@number of days}
The 32400 is the number of seconds to add (this example is for Japan time adding 9 hours)
the 86400 is the number of seconds in a day
If there is a easier way to do this, I am open to any ideas. I hate having diffrent versions of the report out in the field...
Thank-You
Tonya
