Question
Is there any OOTB Pega function to convert any valid date to MM/DD/YYY
I have a requirement where I can get the date in below format, I will not be knowing in what format I have the input . Irrespective of what ever format comes in , it needs to be converted to MM/DD/YYYY.
Is there any way/ OOTB Pega function to covert any date into MM/DD/YYYY without knowing the input format?
If date of birth comes as MM-DD-YYYY If date of birth comes as MMDDYYYY If date of birth comes as MM.DD.YYYY If date of birth comes as MMDDYYYY If date of birth comes as YYYY/MM/DD If date of birth comes as YYYY-MM-DD If date of birth comes as YYYYMMDD If date of birth comes as YYYY.MM.DD
***Edited by Moderator: Pallavi to update platform capability tags***
If you have stated all of the possible input formats, then the potentially ambiguous ones are MMDDYYYY and YYYYMMDD. All of the others are deterministic as to what is the year, month and day.
For MMDDYYYY and YYYYMMDD you will need to know what the range of dates you can receive will be. If the dates are all in years where it is clear from the first 2 digits that it is a year rather than a month, you can use that to decide which one it is. That is, if the years are all from the 19XXs and 2XXXs, you know that any input in the form 19nnnnnn or 2nnnnnnn is YYYYMMDD, where any input of the form nnnn19nn or nnnn2nnn is MMDDYYYY.
As to the conversion, you have your choice. Once you have determined the input format, you can convert into a date by specifying the input format then back into a string in your desired format of MM/DD/YYYY. Or you could just pull the input date apart into "MM", "DD" and "YYYY" components and reassemble them as MM/DD/YYYY.
Not sure how we can do this in any language/platform without knowing what format it is in. If we get the date as 20112010 how can we determine if it is 2011 October 20 (YYYYDDMM) or 2010 November 20 (DDMMYYYY) in any language/platform?
Will year be always YYYY and DD comes always after MM (for example MM/DD/YYYY, MM-DD-YYYY, MMDDYYYY, MM.DD.YYYY, MMDDYYYY, YYYY/MM/DD)? If yes we can have some workaround.