I’ve used the meta info many, many times.
As of a few days ago, in EDT my format is yyyy-MM-dd but when opened, it changes to M/d/yyyy and I cannot figure out what I changed to make it do this. Not sure if I’m just missing something obvious here.
EDT:
FILE:
Any help would be appreciated as this is requiring me to manually change the entire column to ingest into accounting.
You mean you output it from Easy Data Transform in yyyy-MM-dd? In what format; CSV, Excel?
Then you opened it in another program and it was M/d/yyyy? What other program?
Please clarify. A sample .transform with inputs that shows the issue would also be useful.
Output to CSV.
I open from the pencil icon in EDT and it has changed the format.
Is there a way to post just a portion of my .transform so as to not post sensitive info?
It is not an issue with EDT, it’s the default date format in Excel, as when you hit the Edit it opens up the file with the default application associated with the extension, in your case CSV is associated with Excel, so when Excel opens it up, it recognizes the date column and display it in the system default date format.
Here is the same in my case. I opened the output in Text Editor, where it shows the same date format as it is shown in the EDT, but in Excel it gets changed to system default date format.
Yes, simply select the column data and copy it and then in EDT choose From Clipboard and then add the steps that is causing the issues and share it over here.
To share only the data, you can click on the Copy the dataset to the clipboard icon 
and then simply paste in here like as follow.
AccountingDate
2025-06-02
2025-06-02
2025-06-02
2025-06-02
2025-06-02
2025-06-02
2025-06-02
2025-06-02
2025-06-02
Transform file.
AccountingDate.transform (2.0 KB)
As @Anonymous says, clicking the pencil icon opens the file in the application that your operating system associates with that file extension. Sounds like .csv is associated with Excel on your computer. Excel is famous for mangling data.
You could change the associate to a text editor. We like the free Notepad++ editor on Windows.
Ya, I hate how excel can get so wonky. It messes up my time’s often as well on import to where I have to do extracts and/or pads.
My only issue is the file must be uploaded as an excel csv into the system.
CSV and Excel are 2 completely different formats. Why don’t you just output an Excel XLSX file?
Sorry my brain went dumb there for a moment.
I’m required to output in .csv but also send the file as an excel spreadsheet. And it just dawned on me that I could just do 2 output files to do this instead of trying to mash into 1 
Yes, you can output to multiple files in different formats from a single transform.
Thank you. I think I was way over thinking it there. Have to remind myself that sometimes it’s just a simple solution haha.
