4 Replies Latest reply on Dec 3, 2012 6:09 AM by Christopher Henderson

    Changing custom serial dates to proper dates

    Christopher Henderson

      Hi All,

       

      I have the attached spreadsheet and wanted to know how to convert the date field which is in a serial format of 201111 - so that is yyyy mm. How do I convert this into a date field that Tableau can read? I am sure at some point I would have to add in a day field, if this is the case we can just use the first day of the month.

       

      Any help would be much appreciated.

       

      Cheers

       

      Chris