Standardize Date Format upon value retrieval from Excel

Hi all, I was wondering if any of you know how to standardize the date format I have in this existing excel column and populate in to a new column based on a “dd/mm/yyyy” format using UiPath. I am new to UiPath and am hoping that you could share some of your tips with me.

Here is how the column looks like (I have yet to remove the strings before the date):



Please check this Xamls,Date_TryParseExact_InvokeMethod.xaml (13.4 KB)

Hi @Sanjay3630,

thanks for your input. However, the challenge I face is that the date format don’t necessarily conform to what is defined in the array of possible dates. This is what I mean:

In this case, how can I parse into dd/mm/yyyy format? Thanks in advance :grinning: