Date Format changing after reading CSV

Help
22

I think the values are getting converted to String after Read CSV. I’ll try to reverse the values to get the old date format. Meanwhile if you get a better solution, please let me know.

1 Like
23

Also any idea when i use Read CSV why the date format is getting reversed?

1 Like
24

as i told you before, if you force excel date format that you want, AND make sure your datatable holds a datetime type, then the format in your csv dont matter, in excel everything will look the way you want…

25

I coudn’t find an answer for the issue. I’ve just manually reversed the dates. And these are for the Advanced training - Assignment 2. I’ve completed the same too :slight_smile:

26

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