ShiftDateTime issue

[campia]

Dear,

I receive from an external database the registration date GMT+1 and the real date is -1.

I tried to change it via the function ShiftDateTime but i get an error. I tried like this:

SchiftDateTime({field_date},"GMT+01:00",GMT)

example:
i get : 09/12/2008 17:00 -> but it must be 09/12/2008 16:00

Can you help me please?

André

 

[lbass]

Have you read the help files on this? You need the name of the new time zone, and to enter the offset in minutes.

-LB

 

[Madawc]

You could also use DateDiff and subtract an hour.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10