1 Reply Latest reply on Feb 28, 2016 9:15 AM by Bill Lyons

    Year and Month Number Fields into Date?

    Rodney Chong

      I'm new to Tableau and I have two number number fields that contain Year and Month (i.e. 2015 and 12) and I want to combine them into a single date field (ie. Dec 2015). Not sure how to do this. Thinking that I would concatenate them and Dateparse them? Thanks.

        • 1. Re: Year and Month Number Fields into Date?
          Bill Lyons

          I recommend the MAKEDATE() function. Just pass in the year, month, and 1 for day:; MAKEDATE([Year],[Month],1)

           

          That said, the availability of some date functions varies depending on the support of the data source. For example, DATEPARSE() is not available for SQL Server. There are many ways to solve this

          1 of 1 people found this helpful