Date and time format

Help Orchestrator
,
1

I created UiPath Studio that works with csv files. When I open it myself the date in the cell reads as dd/MM/yyyy but when I run UiPath it reads as MM/dd/yyyy which makes the date incorrect. Is there a way to fix it? P.S. I fixed the time and date format on the computer as dd/MM/yyyy and it still doesn’t work. When I look at the Trigger page on Orchreatrator I see it will work again. MM/dd/yyyy We can do How can I do it?

2

image
image301×722 5.23 KB

Open by myself

3

Hi @Sarttra

While using Read Range Workbook enable Preserve Format option in the properties. It won’t change the format. Can you check whether the format in Excel is dd/MM/yy or MM/dd/yy.

Regards

4

image
image246×729 4.77 KB

Open by UiPath

5

It converts to MM/dd/yyyy from the start.

6

image

7

It should be like this.

image

8

we recommend not to open CSV files with Excel, but in any text editor e.g. notepad++. So you can rely on what is in the file as content and its formats.

  • Read CSV File Activity
  • do the processing along with needed parsings and format conversions
9

But I need to use a csv file to work with Excel by filtering date data and append it to a table.

10

can also be done with the datatable resulting from the CSV file and after filtering it can be appended to CSV and/or Excel again

11

@Sarttra

if you open csv as text file then you would see the exact format and that is the format you need to use

and any manipulations can be done by reading the data into datatable and then use linq or further activities

cheers

12

What I see is the date dd,MM,yyyy but when I use UiPath read csv and append it to excel the the date is still MM/dd/yyyy and the date is still distorted and reads as a different month. old

13

I tried it and it’s still the same.

14

EXAMPLE.zip (926 Bytes)
This is example of file

15

@Sarttra

then try reading as text file and then use generate datatable and check

cheers

16

as mentioned:

and we see the clear format in csv:
grafik

And same is in the resulting Data Table:

grafik
grafik497×170 26.1 KB

So you can do all processing on this and within the formats

Writing back to a same CSV should be fine
Writing to Excel maybe need a cell reformatting afterwards

Feel free to elaborate more on:

So we wold help you also on this part