3 Replies Latest reply on May 25, 2020 2:58 PM by Chris McClellan

    DATEDIFF function question

    Subhashini Baskaran

      Hello, Considering today's date is 5/21/2020, DATEDIFF('month',#2010-12-31#,TODAY()) gives me 113 days.

       

      when you do this in SQL, you get 112.70.

       

      Tableau DATEDIFF is probably rounding it off to 113. I am looking to get only 112. Basically truncating the decimal instead of rounding.

      Is this possible?

       

      Thanks