Mahalakshmi Dhanasekaran Mahalakshmi Dhanasekaran - 4 months ago 14
MySQL Question

Changing a date format

To convert year column and month column to date column in Tableau

Sample data:

year Month

2014 aug

2014 sep

2013 oct

Expected Date

aug-2014

sep-2014

oct-2013

Please help to solve this.

Answer
str([Month])+ "-" +str([Year])

Create duplicate field and using str function to add the two fields. But this was not help has date field.

Comments