Add 5 hours to a DateTIme field

[frieb]

I need to add 5 hours to a DATETIME field due to Greenwich Time. I need to know what the formula would be.

 

[Madawc]

DateAdd("h", 5, {your.datetime)

It's best to give your Crystal version, but the formula should be the same for all of them.

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

 

[frieb]

Version 11.5........

Sorry, I need to subtract 5 hours (not add)

 

[lbass]

DateAdd("h", -5, {your.datetime})

Also, in CR XI, there is a function called something like "shiftdatetime" (I don't have CR right now) that does the adjustment based on Greenwich Time.

-LB

 

[frieb]

THANKS SO MUCH! That worked!

 

[Farzam]

It worked but , i am calculating a 3.5 hours differenct but it seems that VBA is not calculating the decimals like 3.5 but it dose a fixed number like 3

any solutions

cheers,

 

[Madawc]

This is really a new issue, so please start a new thread. Also explain what 'VBA' is.

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