Yeah - I don’t get to determine what date format 3rd party reports are generated in before I import into excel.
But excel has formatting options specifically designed to address this that it just ignores half the time.
Comment on Perspective
ryo@lemmy.eco.br 2 months agoThe solution for that is using a sane format for dates.
Yeah - I don’t get to determine what date format 3rd party reports are generated in before I import into excel.
But excel has formatting options specifically designed to address this that it just ignores half the time.
FinishingDutch@lemmy.world 2 months ago
When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.
I still usw the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.
YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.