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?