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:
left(DATE,4) & '-' & Mid(DATE,6,2) &'-' & Right(DATUM,2) & ' ' &
left(TIME,2) & ':' & mid(TIME,4,2) & ':' & Right(TIME,2)
....... and did not Work.
what am I doing wrong?