Converting a Report for time zones

[rsunra]

G'day I have following formula and I would like the time to be displayed in a different timezone for the report ie add 3 hours of 2.5 hours.


datetime (Totext ({Event_Date}, "dd/MMM/yy&quot & " " & Totext ({Event_Time}, "HH:mm:ss&quot)

 

[synapsevampire]

What does add 3 hours of 2.5 hours mean?

You can add 3 hours to a datetime like this:

dateadd("h",3,datetime (Totext ({Event_Date}, "dd/MMM/yy&quot & " " & Totext ({Event_Time}, "HH:mm:ss&quot))

There's also a UDF which does some timezone stuff:

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

And depending upon your database and Crystal version, you might have it converted and returned on the server side using a SQL Expression.

-k

 

[rsunra]

Thanks!

The 2.5 was for South Australia

With your help I was able to work it out with the following:

DateAdd ("h",2,dateadd("n",30,datetime (Totext ({Event_Date}, "dd/MMM/yy&quot & " " &
Totext ({Event_Time}, "HH:mm:ss&quot)))

Cheers