CSV File - Date Format
Hello YF Community,
I'm trying to import data using CSV File. I know the accepted date format has to be yyyy/MM/dd.
The problem is I'm not able to save the date format as yyyy/MM/dd in CSV. I have tried to keep yyyy/MM/dd format and save the csv but next time when I open the file, it's back to its default format of dd/MM/yyyy.
The reason I want to import in yyyy/MM/dd format is to be able to use the pre defined date functions in YF instead of doing a Date Convertion while doing the CSV File preparation in YF.