7 Replies Latest reply on Aug 19, 2016 6:45 AM by Raymond Xie

    Showstopper!!! Tableau failed to parse string to datetime

    Raymond Xie

      I have a log file where there is a string field to be parsed to datetime, my current issue may NOT be with the function, but possibly be with Tableau itself:

      The function with the same log has been tested by another Tableau user from stackoverflow and everything is working as expected, but same function with same log is NOT working on my Tableau.

       

      Here is the function:

      DATEPARSE('dd/MMM/yyyy:HH:mm:ss',[timestamp])

       

      Note at the bottom it says "The calculation is valid"

       

      Here is the screenshot:

       

      Screenshot - 2016_8_16 , 17_16_01.jpg

       

      I've put my log file here if you want to try on your side:

      http://webdesignstudiotoronto.com/cleaned_final.csv

       

      The log is 11,290KB

       

      Any clue is appreciated.

      Thank you very much.