2 Replies Latest reply on Mar 11, 2016 7:53 AM by Joeseph Elias

    DATEPARSE Returning Noon as "00" instead of "12"

    Joeseph Elias

      Hi All,

       

      Below table with a date field (work start), which tableau thinks is a string and  needs to be converted into a date.

       

       

      I used the below DATEPARSE Formula to do so, and it works expect for the 12 o clock (or noon) values are coming back as 00. You can the highlighted 12:36 time above is being converted to 00:36. However the other two times in the example display correctly in the 24 Hour format, even the one past noon (14:11) This happens for all noon times in the workbook, and all other non-noon times convert correctly.

       

      I tried Trimming the EST off and that did not help either.... Any ideas or insight would be much appreciated!

       

      Thank You,