11 Replies Latest reply on Jan 5, 2015 8:12 AM by daniel.rodrguez

    DATEPARSE doesn't parse correctly some hours in AM or PM

    daniel.rodrguez

      Hello,

       

      I'm parsing an timestamp from an Excel file, but in some cases, the DATEPARSE function is not parsing correctly the hour of the timestamp, and where it should consider PM it's considering AM, and it seems that it's only happening when the original hour is between "12 PM and 13 PM", it converts the hour between "00 AM to 01 AM".

       

      See printscreens below below:

       

       

      "Horodotage" column (original string with date/hour)

      "Date Hour" column (parsed data)

       

       

       

      Do you have any idea of what can be wrong?

       

      Best regards.


      Daniel