Convert different(multiple) types of date into the one fix date format

Hi,

Can you try the following expression?

CDate(System.Text.RegularExpressions.Regex.Replace(currentItem,"(\d+)\W+(\w+)\W+(\d+)","$2/$1/$3").Trim).ToString("dd MMMM yyyy")

Sequence.xaml (6.5 KB)

Regards,

2 Likes