I have a date/time value as a string in the following format: “yyyy-MM-dd” in data table. Once I write this data table into a .CSV file using Write CSV activity, the format is changing to this: “dd.MM.yyyy”. I know that this is because Excel is changing the format.
My question is “Is there any way to force the Excel not to change the format while writing from data table to csv file, or anything I can do while writing into csv file in Studio?”
Any suggestions are much appreciated.