GMT Time Conversion

fragglemoo · Apr 8, 2008

I have a date/time field that needs converting. I'm in the UK and the times on this field are now 1 hour out due to BST.

I'm using CR2008.

Thanks

Madawc · Apr 9, 2008

Try

Code:

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

Or better, make it flexible using a parameter:

Code:

if @Summertime = "Y"
then DateAdd ("h", -1, {your.datetime})
else {your.datetime}

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