Hi To format Date column?

Hi UiPath Community,

I hope someone can help me with my situation.

let say I have the following data below:

For my expected output please refer on the output portion

Thanks and Regards,


Hi @aapostol

Use the Below function to convert into specified format!

DateTime.ParseExact(row("columnname").ToString.Substring(0, 10),“MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).toString("yyyyMMdd")


1 Like

Hello @aapostol

Below is the working requested output for the same:-

Instead of ‘str’ you have to replace ‘row(“columnname”)’ as I have mentioned below:-

DateTime.ParseExact(CDate(row(“columnname”)).ToString(“MM/dd/yyyy”), “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyyMMdd”)

Mark as a solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.