4 Replies Latest reply on Aug 10, 2018 10:24 AM by Edwin Niculaescu

    Survey Monkey Date Field

    Edwin Niculaescu

      Hello,

       

      I have a Survey Monkey integration and the date comes in as a string in the following format '2017-07-19T17:46:08+00:00'. I do a split at the 'T' to get the date '2017-07-19'. I then want to convert the data type to 'date' but I get the error below:

       

      • No such function SPLIT that takes arguments of type (str, str, int).
      • Unable to properly calculate the domain for the field 'Date split'. Displayed data may be incorrect.

       

       

       

      Any suggestions on a better way to extract the date and actually have it as a date data type?

       

      Thanks!

      Edwin