Convert datatable to dd/mm/yyyy

Help
, , ,
1

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

image

Please guide me about convert to dd/mm/yyyy

2

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

3

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

4

@fairymemay

Check below post

Hope this helps

Thanks

5

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
6

Use like below.

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

7

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

8

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

1 Like
9

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