Question 1
You are analyzing a dataset containing sales transactions where the 'Order Date' field is currently recognized as a String data type (e.g., '20230115'). You need to use this field for time-series analysis in Tableau. Which method efficiently converts this field to a Date type without modifying the underlying source file?
Answer and explanation
Correct answer: A
The DATEPARSE function is specifically designed to convert string fields into date fields by allowing you to specify the exact format of the string (e.g., DATEPARSE('yyyyMMdd', [Order Date])). While clicking the data type icon is also possible, DATEPARSE offers precise control for non-standard formats.