How to convert a string to date

HI @Chendoran_M

You can try with Format Cell activity to change the format of the date

Check out this thread

How about this expression

DateTime.ParseExact(YourInput.ToString,{"yyyyMMdd","yyyyMMd"}, System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd/MM/yyyy")

Regards
Gokul

1 Like