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***
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.