ConvertToLocalTime silly question

Wed, 14 May 2014 22:49:16 GMT

Hello.

I have two fields, one with a date and another one with the time. Both fields are in UTC Time zone and I want to convert to GTM.

I was using function ConvertToLocalTime() but I'm not able to make it work for some reason.

I tried with ConvertToLocalTime(DATE + TIME, GTM()), ConvertToLocalTime(date(DATE, 'YYYY-DD-MM') + time(TIME,'HH:MM:SS'))

and also with something like this:

ConvertToLocalTime(

chr(39) &

left(DATE,4) & '-' & Mid(DATE,6,2) &'-' & Right(DATUM,2) & ' ' &

left(TIME,2) & ':' & mid(TIME,4,2) & ':' & Right(TIME,2)

& chr(39),

GTM()

)

....... and did not Work.

what am I doing wrong?

thanks.

topic ConvertToLocalTime silly question in QlikView