Crystal 7.0 Convert DateTime to UTC 1

[shenay921]

Hi There,

I need to take a datetime and add 7 hours to it to give me a new datetime in Crystal 7.0. Such as datetime 8/26/2008 20:00:00 and convert to 7 hours ahead: 8/27/2008 03:00:00.

I know versions 8.0 and higher have the DateAdd ability -- what can be done in 7.0? I haven't been able to locate any posts in regard to this.

Thank you.

 

[lbass]

You could try adding a hard value that equates to 7 hours/24 hours, as in:

{table.date}+.291667

-LB

 

[shenay921]

Nice job! That worked! Thank you!