2 Replies Latest reply on May 7, 2013 3:36 PM by Chris Smith

    Creating data from month and year columns

    Chris Smith

      Hi,

       

      I have a data set that has a MONTH (e.g., "Jan," "Feb," "Mar) column and a YEAR column (e.g., "2013," "2012," 2011") and I want to create a calculated field that will create a Tableau-friendly date from which I can produce pretty graphs.

       

      For the day value, I would like to use "1" for each month as a dummy value.

       

      Any suggestions on how to proceed?

       

      I tried this without success:

       

      Datetime (STR([Month_Key - Long Name])

      + "/"

      + "1"

      + "/"

      + STR(MID([Year - Long Name],3,4)))

       

       

      I also tried this without success:

       

      Datetime (STR([Month_Key - Long Name])

      + "/"

      + "1"

      + "/"

      + STR(MID([Year - Long Name],3,4)))