Hi everyone,
I have a column in my dataset with dates formatted as "yyyy-MM-dd". As you can see in the attached screenshot, the column is a string. Not matter what I do, I cannot seem to make a calculated field where Tableau recognizes it as a date.
I have tried DATE([field]) - which returns null. I have tried DATEPARSE("yyyy-MM-dd", [field]) - which returns null. I have tried simply using DATE() with a hardcoded date (e.g. "2023-08-09") in various formats (e.g. 2023/08/09, 08/09/2023, 08-09-2023, etc.) - which also returns null.
When I switch from Live to Extract, suddenly DATEPARSE() works, though the data source pane still shows null in the calculated column. Do these functions simply not work with a live connection? Or am I missing something obvious here? Any help would be appreciated.
Thanks
@Brent Henry some date functions does not work with live connections. Can you try like below:
DATE(DATEPARSE("yyyy-MM-dd", STR([field])))
