How to transform AM PM Date/time formats

Document created by pete_mccoy1.3055586893899446E12 Employee on Oct 8, 2013
Version 1Show Document
  • View in full screen mode
How do I set the Date Format Option on my flat file csv map profile date field to handle a date that will come as both these formats:

10/1/2013 5:05:00 AM
10/10/2013 5:05:00 PM
Set the inbound profile to handle the hours as lower case 'h' to signify hours in am/pm, and add the am/pm symbol marker 'a' to the mask.

Input profile Date/Time mask
MM/dd/yyyy hh:mm:ss a
Output Profile Date/Time mask - (any valid date/time format)

Please remember that you are not restricted to the data masks that are contained in the drop down list.  You can use any data mask as long as it is valid.  See the documentation at this link for additional information on date/time data formats:

Then perform a straight map from one date element to the other, Boomi will handle the the date format conversion function behind the scenes in the mapping,  as described in the "Note:" section of the documentation at this link:
1 person found this helpful