If My DOB data contains 03/11/2022(MMM/dd/yyyy) or 03-11-2022(MMM-dd-yyyy) my bot was able to separate Month, day, Year with the below expression
And Passing the DOB successfully into my application.
But when My Excel column contains above mentioned date formats
Feb 03 2022
2022 03 Feb
the bot was unable to separate them
Can Someone help me on these issue
in addition to @ppr suggestion you can convert the entire date column in to a suitable format and append at the end of the dt and use this column for further processing. This step is sort of a data massaging