Hi all,
I'm using crystal reports 11 and I'm trying to adjust the date/time data in the DB (SQL) for daylight savings.
The data is stored in GMT time and when I bring it up its also the GMT time. I'm based in the UK so I thought I could do a IF then else formula. eg if the current time is not equal to the current time in the DB. then the date/time value add 60 mins. (but I dont think this is the right logic/method)
I'm very new to crystal and any help is appreciated.
Thanks
Tom
I'm using crystal reports 11 and I'm trying to adjust the date/time data in the DB (SQL) for daylight savings.
The data is stored in GMT time and when I bring it up its also the GMT time. I'm based in the UK so I thought I could do a IF then else formula. eg if the current time is not equal to the current time in the DB. then the date/time value add 60 mins. (but I dont think this is the right logic/method)
I'm very new to crystal and any help is appreciated.
Thanks
Tom