We are currently trying to solve a date format incompatibility issue with one of our Vendors.
The vendor's expectation for the Date of Birth (DOB) attribute on our Outbound SAML is of format "yyyymmdd".
But our current available format is "mmddyyyy".
Can anyone please advice on how this can be tackled using Regular Expressions.??
We are exploring other options from an LDAP and vendor side code fix perspective, but all the options are adding heavy SLAs and we currently cannot afford to lose time.
I am very optimistic that RegEx can prove helpful here.
Every suggestion is appreciated. Thanks for your time.
I don't have a test environment up and running at the moment to test this for you, but you should be able to use the expressions to manipulate the data.
Something like this expression should rearrange the date: RIGHT(dateattribute,4)+LEFT(dateattribute,4)