how to adjust data date/time for time zones

[dg3249]

Hi,

I need to adjust the data date/time fields for Australian time. Not sure how to go about this. Any help would be appreicated.

 

[Naith]

Use a formula on your date fields. Depending on your Crystal version, you can use DateAdd for this.

DateAdd("h",[Enter the time difference here without the square brackets, like -10 or something], {Database.Date})

Naith

 

[synapsevampire]

Hopefully your request is that the datetime fields be displayed in some Australian timezone, wich is easily accomodated by setting the PC to the appropriate timezone.

Or perhaps you have to serve multiple clients.

One of the strongest contributors here (Ido Millet) has the best solution I've seen for this in the form of a UDF.

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

This converts timezones.

Oracle 9i allows for timestamp with timezones embedded, which I've used successfully on one international project, but Crystal does not support them, so you'd have to convert the timezone in a View/Stored Procedure.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dg3249]

I am using the special fields data date and data time. Can you use the above formula with these special fields.

Diana