AnsweredAssumed Answered

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 and AM10/10/2013 5:05:00 PM .

Question asked by WayneCreekmore666 on Oct 4, 2013
Latest reply on Oct 7, 2013 by mike_aronson
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

Notice the day field will come as a single digit and also as a double digit.
Also, how do I handle the AM, PM?

This is the input source data, the output will be set in the output profile as "MM/dd/yyyy HH:mm".

Outcomes