0 Replies Latest reply: May 14, 2014 6:49 PM by Victor Machuca RSS

    ConvertToLocalTime silly question

      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.