6 Replies Latest reply on Oct 27, 2016 7:26 AM by Joe Oppelt

    Convert MMM and YYYY columns to one date column

    Jaakko Salminen

      Hello,

       

      I have data that has a column "month" which is in format MMM and another column "year" in format YYYY. I am having trouble creating a Date column which Tableau can understand. Dateparse could possibly help but it is not available since the data is in an Access database and I am using an SQL query.

       

      So this is basically what I need to do:

       

      Year     Period                    Date

      2014     Jan                       01/01/2014

      2014     Feb          ->         02/01/2014

      2014     Mar                      03/01/2014

      2014     Apr                      04/01/2014

       

      Any suggestions?