13 Replies Latest reply on May 17, 2017 11:19 AM by Shinichiro Murakami

    Date - change to Semester-Calculation Error

    Jan Costello

      I am trying to convert a date to a semester. In Excel, the dates are listed as 04/01/YEAR or 11/01/YEAR.  I would like it to say Spring YEAR or Fall YEAR.

       

      I am entering the following in the calculation field:

      IF DATEPART (‘04/01’, [DATE])< 6 THEN ‘SPRING’ELSE ‘FALL’ END

       

      Tableau says there is an error -- a bad character at ('04

       

      I am using Tableau 10.2

       

      I would appreciate help.