dates

[altec101]

Hello,

I have a report that is displaying the date from a table that is pulling its information from a server.
The time that it is returning is 3 hours ahead of the original information on the server where it pulls the info from.
I was able to adjust the time on the report to reflect the same time on the original information coming from the server using the DateAdd("h",-3,[column name]) function.
The only problem is that if the info pulled from the server was before day light savings time, the time would be off again by about an hour.
Is there a way to adjust the time correctly in the report for my time zone and have it include the day light savings time?


Thanks

 

[powerz]

How about use iif()
DateAdd("h",iif(yourDate>dateStart and yourDate<dateEnd,-3,-2),[column name])