AnsweredAssumed Answered

Help : European Date Format Conversion

Question asked by ukamble361217 on Feb 21, 2017
Latest reply on Feb 22, 2017 by aarthi_sridhar

We are using flat file as profile and it has three date field. We have done all validation logic considering date fields are in MM/DD/YYYY hh:mm:ss format.

 

But we sometimes get file in UK date format also which is DD/MM/YYYY hh:mm:ss.

 

I am planning to have two process properties one for accepting 1) date format  and 2) Delimiter from client.

 

So if file is in UK format client will mention....

Date format - DD/MM/YYYY

Delimiter - /

 

Now, we have to convert the input files 3 date fields from format DD/MM/YYYY hh:mm:ss to MM/DD/YYYY hh:mm:ss

 

How can we do that? Do we have any script or map function for same?

Outcomes