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,
AA
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,
AA
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")
Regards
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
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.