In the database I have date field format - mm/dd/yyyy but the data type as string and still the ETL guys are trying to fix it , but for reporting purpose I want to cast its data type as DATE in the custom SQL WINDOW
select record_id ,cast(period_dt as Date) from EXCEPTION_LOG
it is returning #error in the date fields may I know how to cast because I have to join with date field between two tables .
In the database also to join both those tables we are using cast and parse functions and if I use the same query it is not working in Tableau
What database are you using? SQL Server, Oracle, other? That could impact the syntax of the SQL.