Issue with date format from csv to excel

Help Forum
1

In csv file i have date forma but when i copy it in excel file i have for some rows text format

image

2

Hi @Soudios

Did you try reading it with Read CSV in UiPath and saving it in a data table. What is the format in data table.
If possible please share the csv sample.

3

Here a screen from csv file, all the date have the good format.

I use read csv output data table

image
image248×686 16.8 KB

4

Read the CSV directly in the UiPath studio

5

ithats what i did, i don’t really understand your point

6

What is the challenge that you are facing?

7

my csv file have good date format but when i copy the file in excel the format change (I need to copy it in excel because i have a template with formulas)

8

How are you copying it in excel (which activity)?

9

yes with write range activity

10

It is actually showing date in improper format for rows which have date less than equal to 12 (dd)

11

@kumar.varun2
Ok so how can i fix that ?

12

can you right click on csv file and open it in notepad to see the format of date.

13

image
image210×703 9.93 KB

14

@Soudios

check the attached xaml file
Correct Date.xaml (8.6 KB)
emp.txt (98 Bytes)

change the extension of emp.txt file to .csv

15

image
image1032×484 12.3 KB

16

@Soudios

The missing activity is excel application scope in which I am using write range to write the outDT to an excel file.

image

17

I don’t really understand your method

18

Did you run the workflow and saw the output?

19

It still txt file
image

20

image

First uncheck this check box

This PC → View ->Options->Change Folder and Search Options