Date Format conversion is not working as expected using Date Parser

[kaushikr931]

Hi All,

                I have a requirement where I need to convert the date format in order to populate them in SNOW ticket . I need to convert date incoming in as 12-hour format to 24-hour format . I’m using Library/Utility Operations/Date and Time/Date Parser operation from Base 1.11.0 content in OO 10.80 . I have 3 scenarios mentioned below :

1. This works as expected . Input is 20180720 023000 and output is 2018-07-20 12:30:00 .  Attahcment date1.jpg
2. This didn’t work as expected . Input is 20180720 123000 and output should have been 2018-07-20 12:30:00 but it returned 2018-07-20 00:30:00 . Attachment date2.jpg
3. This also works as expected . Input is 20180720 223000 and output is 2018-07-20 22:30:00 . Attachment date3.jpg

Has anyone come across this ? or is this a known issue ?

Can we overcome this by using the latest Base content pack ?

[JarodMB]

You're using a 12-hour mask value which relies on an am/pm marker - because the marker is missing it sees the value as being am

[kaushikr931]

hi Jarod,

i tried that also but same issue . Attachment date4.jpg

[JarodMB · Accepted solution]

The problem is on input - it sees the value as an AM because the AM/PM marker is not specified 
add PM to your input timestamp, aa to your input format
i.e.
  20180720 123000 PM
  yyyyMMdd hhmmss aa

you can remove aa from your output as you're exporting to 24 hour format