1 of 1 people found this helpful
Hi there! Are you using a live SQL connection? DATEPARSE() can't be used on all data sources. Here's a quote from the documentation:
Note: This function is available for non-legacy Excel and text file connections, Google Sheets, MySQL, Oracle, PostgreSQL, and Tableau extracts
To solve this, you can either extract your data source or change to a different function. For instance, DATE() works on all data sources.
2 of 2 people found this helpful
As David has already mentioned, DATEPARSE() is not available with some of the source in live connection. And to fix this use extract instead of live. If you have constraints like you've to use live connection only then you can try with DATE().
Find my approach,
Let us know if this helps,
Thank you. I used an extract before, but when I uploaded the datasource, accidentally it became live. Therefore the dataparse didn't work anymore (SQL Server).
The "DATE" function is not working in the formula below as suggested.
DATE(DATEPARSE ( "yyyy/MM/dd", LEFT([Time - Split 1], 4) + "/" + MID([Time - Split 1],5,2) + "/" + RIGHT([Time - Split 1],2) ))
Could you please share some sample mock up data in a packaged workbook to validate the logic which you have mentioned?