Converting Time Zone on a Report Field

[FrEaK_aCcIdEnT]

I have a field on an access report that is in EDT and I need it to be in CDT. -1:00:00. The field is long date/time format. How can I achieve this? I am still new to the advanced access functions.

Thanks in advance!

 

[alansidman]

If you use a query as your record source for your report, then create a new field and put an expression (formula) =DateAdd("h",-1,[fieldNameHoldingTime])

 

[Micron]

Too bad you didn't say if it's a textbox, bound or not, what its name is, what the data source is... If it's a combo box for instance, my suggestion will not work.
You will have to figure out if you should replace nn with the name of your field or name of your control and replace TheTime with a reference that does not create a circular reference.
nn=DateAdd("h", -1, [TheTime])

You could also check out the DateAdd function for more info.