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