1 Reply Latest reply on Aug 7, 2012 2:35 AM by Andrew Watson

    Dates with just YEAR not identified by TABLEAU

    fahim m

      Hi

      First,

      I have a table with just the YEAR (ex -2005) column and want to calculate the difference in number of years using DATEDIFF compared to TODAY. Tableau does not identify just YEAR as a date field. Any sugesstions on how to handle this.

       

      second,

      I plan to use DATEDIFF('year', YEAR, TODAY()) to calculate the difference (to get the number of years elapsed compared to TODAY)

      Thanks much, I appreciate any help.

       

      Fahim.