1 Reply Latest reply on Jan 17, 2019 12:14 PM by nick.jordan.0

    Convert Month (String) and Year (Integer) to 01/mm/yyyy

    nick.jordan.0

      Hi Tableau Community!

       

      I have a data set which has two separate attributes that I would like to combine into one single date attribute but I am running into some difficulties.

       

      Attribute #1 is the month formulated as a string : ex. January, February, March, April, May, June, July, August, September, November, December

      Attribute #2 is the year formulated as an integer: ex. 2015, 2016, 2017, 2018, 2019

       

      How can I combine these attributes to form a Tableau date dimension which has 01/mm/yyyy format?