I have a report which shows date as e.g. 2016-11-20, which when I connect via tableau can only recognise as a string, and I cannot convert to a date.
Thankfully within the same excel sheet they have headings for "Sales Year", "Sales Month" and "Sales Day", all stored as #.
When I try to generate a calculated field though using the following text, the result cannot be recognised as a date:
DATE(([Sales Month])/([Sales Day])/([Sales Year]))
Can anyone advise how I can use the 3 components, or additionally the date and time given I also have "Sales Hour" and "Sales Minute" in the spreadsheet also?
Check the MAKEDATE and DATEPARSE functions - one of those should do what you need.
Thanks very much Andrew, I appreciate that.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...