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?