4 Replies Latest reply on Jun 12, 2017 7:26 AM by Suzanne Heino

    [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: Error converting text to date

    Alvaro Fernandez

      Hello!

       

      I am using a Redshift connection in Tableau 10.1 and when I have fields in Date format it cannot load and the following message appear.

       

      [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: Error converting text to date

       

      It happens when I have the data source in Live and also when I am trying to reload the data source in Tableau Server.

       

       

      I am also trying to load the date field as string and then building a date from it with string functions but error persist.

                date(RIGHT([s_date],2)+"/"+MID([s_date],6,2)+"/"+Left([s_date],4))

       

       

      Is there any solution?

       

      thank you in advance