How can I keep date format in csv file when I create CSV which data come from datetable

Help Studio
, ,
1

Requirement:

  1. I have one excel contain date type column(EG. Birthday, format is yyyy/mm/dd)
  2. I need save as new csv file
  3. The csv file birthday column should keep date type
    Test_20240307.xlsx (8.6 KB)
2

@Lori

  1. First when you read from excel if the preserve format or the display value is not selected then the date column data is read in a different format…so use preserver format or display value and read the data then use that datatable to save it to csv

Cheers

3

Yes, It works, I forget this option, thanks.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.