Date format problem

[BlueBird1 (BluebBird)]

Hey community, I have a problem I developped a workflow that has as an input a data containing date column dd/mm/yy but after executing the workflow the format date become mm/dd/yy

but I want to keep the same format at beginning HELP

[arjunshenoy]

Hi @BlueBird1

At the time of writing the data, you can explicitly convert the mm/dd/yy formatted data to your desired pattern & write it. You can use this expression for the same:

yourDateValue.ToString(“dd/MM/yy”)

Hope this helps,
Best Regards.

[fernando_zuluaga]

Hi @BlueBird1

• If you are gettin the data from excel, make sure to set the Preserve Format property enabled.
• Another solution is to convert the data coming to the format we want

DateTime.ParseExact(yourStringVariable, {"M/d/yy","dd/MM/yy","d/M/yy","MM/dd/yy","MM/dd/yy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yy")

Regards!

[BlueBird1 (BluebBird)]

Actually I didn’t write any dataTable, M just workinng with an excel file and I want to keep the same input format

[supermanPunch (Arpan)]

Hi @BlueBird1 ,

Maybe you could check the below Post :

DateTime.ParseExact the whole Column without looping

Hi @arthurang , If the Target Goal for you is to represent the dates in Excel Sheet Column in MM/dd/yyyy format, maybe you could use the Format Cells Activity if you have the latest versions in place. [image] You would require to know which column the Date column is present (A or B or C, in my case it is J), then we can use the Range as J:J. If we do not know the position of the column in the Excel sheet too, we can dynamically be able to find it as well. Input : [image] Output: [image] …

[arjunshenoy]

@BlueBird1

If you want to keep the data format intact from the time of reading the data, you can use a property called Preserve Format in the Read Range activity.

Selecting this check box keeps the formatting of the cell that you want to read. By default, the check box is cleared.

Hope this helps,
Best Regards.

[BlueBird1 (BluebBird)]

I will try tthis method and I’ll let u know

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

Hi @BlueBird1

By Default format of date time in UiPath is MM/dd/yyyy only.
So i you want to Same format after getting your datatable u have to Convert the format with below expression

DateTime.ParseExact(YourVariable,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Thanks
VP

[BlueBird1 (BluebBird)]

@supermanPunch I got an error:
Format Cells: Cannot set NumberFormatLocal property of Range class.

[BlueBird1 (BluebBird)]

@arjunshenoy this is how read range properties look like

[BlueBird1 (BluebBird)]

should I put in the bloc variable the name of my column?

[BlueBird1 (BluebBird)]

@Vishnuraj_Pandiyarajan2 I tried what you said and it return this error: Assign: String ‘DATE_TRAITEMENT’ was not recognized as a valid DateTime.

[yikwen.goo]

Does the text “DATE_TRAITEMENT” appear anywhere in your column containing the dates? Is it the name of the column header or a variable in your workflow?

[BlueBird1 (BluebBird)]

Yes it’s the header

[yikwen.goo]

Ok so that means the header text is also being fed into the function to parse as date. Can you read the data treating the first row as the header? Just double check that the “A des en-tetes” checkbox is checked.

[BlueBird1 (BluebBird)]

it’s already checked

[yikwen.goo]

Hi @BlueBird1 ,

So here are the required steps:

1. The input data’s “DATE_TRAITEMENT” column contained text in the format of d/M/yyyy, e.g. 3/5/2023.
2. To ensure that the output Excel formats the date correctly, create a blank output template with the DATE_TRAITEMENT column cells set to the date format of d/M/yyyy
3. In the robot workflow, parse the values in the DATE_TRAITEMENT column as dates by using the following code DateTime.ParseExact(CurrentRow("DATE_TRAITEMENT").ToString, "d/M/yyyy", System.Globalization.CultureInfo.InvariantCulture)
4. When writing out the Excel, copy the output template and give it the name of the output file that you want.
5. Write the datatable into the output Excel file. The formatting set in Excel will ensure that the date is formatted correctly.

[arjunshenoy]

@BlueBird1

Just before writing it into an Excel sheet, you can transform the data. Use the Invoke Code activity like this:

Keep the Edit Arguments panel like this:

And, paste this code in the Edit Code Panel:

io_dt.AsEnumerable.ToList.ForEach(Sub(row)
row(“DATE_TRAITEMENT”) = DateTime.ParseExact(row(“DATE_TRAITEMENT”).ToString,"dd/MM/yyyy", Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")
End Sub)

Hope this helps,
Best Regards.