4 Replies Latest reply on Dec 12, 2016 6:07 AM by Jim Dehner

    String to date error

    TVTY BI

      Hi guys,

       

      I am trying to figure out why Tableau does not give me the same result than Excel when forcing a string to date.

       

      For example, DATE(FLOAT('42735.8')) in Tableau will display January 2nd 2017

      whereas Excel will display December 31st 2016. The correct date is the Excel one.

       

      Any idea why Tableau keeps adding 3 days?

      Thanks a lot for your help.

      P.