2 Replies Latest reply: Jun 3, 2018 11:47 AM by Andres Garcia RSS

    Convert to Local Time Issue?

    Andres Garcia

      Hi Experts,



      I am trying to convert a Datetime field from a MS SQL DB on EST  to my current Timezone:


      1. If I user LocalTime() Function it Shows my System has the time Zone two Hours ahead, If I user LocalTime('Central America') Shows my current time, this is the scenario I expect to happen.


      2. But when I use the function ConvertToLocalTime(DB Date Time Field,'Central America') it shows the datetime like 8 hours ahead from when really happened, if Use the same function and instead of using 'Central America', I use 'UTC-02:00' I get an approximate Time, but I need to get the exact time based on my location.



      Any thoughts?



      Thanks in advanced