Convert datatable to dd/mm/yyyy

I read excel to build datatable.
In excel column Birthday format dd/mm/yyyy
But after build datatable and write to text file, It change to mm/dd/yyyy


Please guide me about convert to dd/mm/yyyy

@fairymemay Did you mean Output Datatable Activity ? :sweat_smile:

I write to text file but format birthday output is wrong.


Check below post

Hope this helps


Hi @fairymemay

Also you can try using change the cell or column format Activity by @balupad14 which is given der in below thread :-

Mark as 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

Use like below.

DateTime.ParseExact(Yourdatevariable, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).Tostring(“dd/MM/yyyy”)

[quote=“fairymemay, post:1, topic:244195”]
o text file, It change t
[/quote]Assign it into a string variable and write into text file

Please use the “Preserve format” property of the Read Range activity, and it should work.

1 Like

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