Hello All,
I have a connection to live data and the date measure, that I want to use to filter the data, is in the format YYYYMM.
Changing the data type to Date doesn't work and the DATEPARSE option doesn't even look like it is in Tableau 10.1
How can I tell Tableau to read 201708 as August 2017 and to display it as a date?
Many thanks,
Darren
5 answers
Different data sources support different functions. Tableau data extracts (tde) will support DATEPARSE(). So that's an option.
Change your field data type to a String from a Number (which Tableau defaulted to). Then create this calc:
DATE( LEFT([Calculation1],4) + '-' + RIGHT([Calculation1],2) + '-01' )
