1 Reply Latest reply on Dec 10, 2017 5:59 PM by Shinichiro Murakami

    Time Zones Mismatch when Comparing Date-Time to Date

    Marc Grigoruk

      Hi All,

       

      I am currently running the following formula from Salesforce data currently being extracted to tableau online server:

       

      IF CaseDate=DATE(Date-Time Edited) THEN 0 ELSE 1 END

       

      However, we are in Australia and when the Date-Time Edited field occurs in the morning (Australian time). It appears to be adjusting time back to UTC and returning a date from the previous day.

       

      Specific Example:

      Date-Time Edited in SF= 16/11/2017 9:58 AM

      Tableau formula = DATE(Date-Time Edited in SF)=15/11/17

       

      I am assuming that Tableau Online is converting the Time in the Salesforce Field back to UTC, is that correct?

       

      Other than DATEADD is there an alternate solution to this issue?