2 Replies Latest reply on Jun 3, 2018 2:43 PM by Ken Flerlage

    Cast String to Date  in  New Custom SQL Window

    vamsi krishna

      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