4 Replies Latest reply on Nov 8, 2016 10:42 AM by Christoffer Haaland

    Format Month/Year to compatible date

    Christoffer Haaland

      Hi guys,

       

      My first post to the Tableau Community so I apologies if I've mislabeled the questions or anything like that.

       

      I'm currently having problems reading some data in Tableau which is an export from Data Workbench (see attachment). The date is currently formatted MMM'YY, and I want to change create a calculated field (or something else) that can format this into a format Tableau can read. Unfortunately we can't change this in Data Workbench, so I have to do this manually in Excel. Changing it from say "Nov'16" to "Nov-16".

       

      Thanks

       

      Chris