How to handle different Date formats:


New Member
We have scenario where users enter the date in the email body (free text).
Ex: Start Date : 08\24\2021
Start Date : August 24, 2021
Start date : 24\08\2021
Start date : July 24, 2021 @ 3:12 PM

I am able to get the entire text followed by Start Date: XXXXXXXXX, Using RegEx
Now I need to format the text to date in the MM/DD/YYYY format.

Please suggest if any utility is already there or any VBA code, that I can customize.

Any help on this regards will be greatly appreciated.

Thank you.


Active Member
FormatDate([Your text data item],"MM/dd/yyyy") will give you 8/24/2021. I have not tried it on the "August 24, 2021" value but give it a shot. This should work with any input style.