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

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

Convert datatable to dd/mm/yyyy

Srini84 (Srinivas) August 10, 2020, 10:23am 4

Check below post

Hope this helps

Thanks

Topic		Replies	Views
Excel: Data goes from dd/MM/yyyy to MM/dd/yyyy Studio datatable , excel , studio , question , activities_panel	9	3418	March 7, 2022
Convert Date in Datatable Activities database , activities , question	13	2896	March 2, 2022
Date format: Read range as dd/MM/yyyy and write range as MM/dd/yyyy Help datatable , activities , question , data_manipulation	7	8770	November 19, 2019
Date Time format problem Help	21	3399	February 10, 2020
DateTime Convertion Issue in DataTable Activities excel , activities , question	2	220	October 2, 2023