How to change date format in our datatable?

Help Studio
, ,
1

i have datatable how to chage date format.

S.No Date of Registration
1 16-08-2024 18:43
2 16-08-2024 12:52
3 14-08-2024 22:50
4 13-08-2024 19:00
5 10-08-2024 15:33
6 10-08-2024 07:42
7 09-08-2024 21:43
i need this format
S.No Date of Registration
— —
10 01/08/24 00:14
11 31/07/24 13:29
13 28/07/24 20:15
14 28/07/24 15:02
15 27/07/24 17:14
16 26/07/24 14:11
17 22/07/24 11:58
2

Hi @domsmgtmeet22

Assign–>

CurrentRow("Date of Registration")=DateTime.ParseExact(CurrentRow("Date of Registration").ToString, "dd-MM-yyyy HH:mm", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yy HH:mm")

This image shows an automated workflow consisting of steps to read a workbook, process each row of a data table to reformat the "Date of Registration" field, and write the data back to a workbook. (Captioned by AI)
This image shows an automated workflow consisting of steps to read a workbook, process each row of a data table to reformat the "Date of Registration" field, and write the data back to a workbook. (Captioned by AI)607×630 28.5 KB

Hope it helps!!

3

The image shows a UiPath Studio interface with a runtime execution error message indicating that an assignment failed due to a string not being recognized as a valid DateTime format, causing a System.FormatException. (Captioned by AI)
The image shows a UiPath Studio interface with a runtime execution error message indicating that an assignment failed due to a string not being recognized as a valid DateTime format, causing a System.FormatException. (Captioned by AI)1885×836 106 KB

error

4

Hie @domsmgtmeet22 use read range activity and save as dt1
use for each row and using one assign activity and pass this codes
Your input date
A "Build Data Table" window displaying a column labeled "Dates (String)" with three entries dated 09-08-2024, 10-08-2024, and 11-08-2024, all at 21:43. (Captioned by AI)

The image shows a piece of code in an expression editor in UiPath, converting a date string from one format to another using the method. (Captioned by AI)
The image shows a piece of code in an expression editor in UiPath, converting a date string from one format to another using the method. (Captioned by AI)983×256 10.7 KB

Change Dates column name with your column name
and then you could use write cell aur write range to write the data back to the excel
your output result
The image shows an expression editor in UiPath Studio, where an assign activity is being used to parse and format a date from a data row. (Captioned by AI)
The image shows an expression editor in UiPath Studio, where an assign activity is being used to parse and format a date from a data row. (Captioned by AI)1301×671 48.4 KB

cheers Happy Automation

5

@domsmgtmeet22

It is throwing the due to the format changes in the excel.
So, While reading the excel,In the read range workbook please enable the preserve format

A screenshot of the "UiPath.Excel.Activities.ReadRange" properties panel highlighting the "PreserveFormat" option under the "Options" section. (Captioned by AI)
A screenshot of the "UiPath.Excel.Activities.ReadRange" properties panel highlighting the "PreserveFormat" option under the "Options" section. (Captioned by AI)405×508 15.4 KB

If you stills persists the issue after this Please share the excel data snippet from the excel.