5 Replies Latest reply on Oct 11, 2013 6:27 AM by Talia Camarena

    Correcting a date field that Tableau is reading as a text string

    Talia Camarena

      I need to correct a date field that Tableau is reading as a text string. The string from my data source is formatted as yyyy-mm (ex. 2013-09). I created the following calculated field:

       

      Date(right([MONTH],2) + "-" + left([MONTH],4))

       

      The calculation is valid but I'm seeing NULL values when I pull the date field into my worksheet. I tried formatting the date field in my worksheet to mm-yyyy but that didn't help.

       

      Any ideas? Thanks!