Date/ Time field formula

[rhoneyfi]

I have a date time field that is in East Coast Time. I would like to convert all of the field to West Coast Time...any idea how?

note: the formula needs to take into consideration the following:


Ex: 5/2/03 1:00 ( 1 am EST) should be converted to 5/1/03 22:00 (10 pm PST)

Thanks

 

[dgillz]

Crystal cannot convert the data in your database, if that is what you are asking for, but it can give you a report of these values.

Dateadd("h",-3,{YourDateTimeField}) will subtract 3 hours from the datetime field. Then you can just format the field the way you want it to look.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

This can be done using a SQL expression, but it is database and version dependent, which you might share in your next post.

There is an excellent UFL offered by Ido Millet, one fo the strongest contibutors here to handle this within Crystal:

http://www.milletsoftware.com/CUT_Light.htm

If you just want a 3 hour less date, create a formula containing:

dateadd("h",-3,{table.datetimefield})

-k