Change Column type to date in CSV file

Help Studio
, ,
1

How to change the column format to date in datatable.
Any idea guys?
@Palaniyappan @Rahul_Unnikrishnan @RAKESH_KUMAR_BEHERA
Thanks and Regards
Sreejith.

2

CSV files don’t have datatypes. They’re just text files.

3

Hi @postwick I totally understood that part.
Can you please help me to change the datatable column type to date.
Thanks and Regards.
Sreejith.

4

Use Add Column to create a new column with datatype datetime.

For Each Row in Datatable

  • assign dateColumn using datetime.parse or datetime.parseexact to convert the string column’s value
5

Hello @sreejith.ss

You can try Format cells activity. But in the datatable and not on the csv file.