Feb 01 2021 03:54 PM
I am trying to figure out why it is that when I exported a spreadsheet, the date is formulated the way we need it to be for further efforts in reporting. Once it has been exported it shows differently which now makes it very difficult to do some of the reporting that is required. Why does the exported file not reflect the original file.
Year/Month/Date, after exported it shows as Day/Year/Month
Thanks,
Brenda
Feb 02 2021 12:15 AM
What do you mean under exporting of file, what exactly are you doing?
Feb 02 2021 06:10 AM
@BrendaKY This is very odd as DD-YYYY-MM is not a known date format that I've ever heard of and not one that excel natively recognizes. could you attach the file (or redacted version) for us to look at? Is that column even formatted/recognized as a date or is it just text? If it is a date I suspect it is a custom number format that someone created and then have to ask who/how/why. BTW, still unclear what you are doing. It appears you are exporting from some other program and opening the output in Excel?
Feb 02 2021 07:00 AM
@mtarler Based on screenshot result is text