2vinaymurthy
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.
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.