Haha I did the same.

It was the Wild West, no standard, everyone used their own date format all in the same shared storage.

I've got most of the office doing it correctly now