Hi Everyone, I am having data in excel sheet as shown, [image] Whenever i display this data using data table, it displays column “DOJ” with its date component and time component, However, i want to display only date component in dd/MM/yyyy format, How can i achieve this without using split() meth…

Date Column in Excel based DataTable UiPath

Manish540 (Manish Shettigar) March 10, 2023, 9:00am 3

Try to read your file with Preserve Format enabled as shown in below screenshot,

and let us know.

5 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Format date from Excel file to DataTable Studio datatable , excel , studio	1	747	February 4, 2021
Convert datatable strings column to datetime Studio datatable , studio , string	12	13479	January 11, 2023
Converting String column in a DataTable to DateTime Studio datatable , uiautomation , activities , error	4	3441	October 6, 2020
Change data column date format Academy Feedback datatable , activities , question , lp_developer_fnd	7	1944	January 25, 2021
Datetime format in datatable Studio	23	1324	November 11, 2022