Help to convert Date and Time 1

[CrysRptDev]

Hi all,

Currently my Date and Time format is in GMT which means it is 4 hours ahead. I want to subtract 4 hours of this date field. For example, it shows as 01-Mar-2009 10:50:10PM but i want it to be 01-March-2009 6:50:10PM.

Any ideas?

Thanks,
T.

 

[IanWaterman]

Use dateadd

Dateadd("h", -4, {Yourdatetimefield})

Ian

 

[CrysRptDev]

THanks,

That works.