Spanish guy working in Japan in an international environment here. Little by little I'm forcing YYYY-MM-DD for file and directory names, and DD-Mon-YYYY as the display format for applications and for the documents I write.
Time for a rant. I recently had to fix a web application where the guy who originally installed it set all the fields to free form text, and dates were a mix of:
- D/M/Y: good, European order.
- Y/M/D: also good, CJK order.
- M/D/Y: who the hell did it, if we never had an American in the project????
- Years with two or four digits. Every time I see a date written with only two digits for the year, I want to kill the motherfucker who did it.
- Months written as numbers, full names, or abbreviations.
Well, at least nobody used Japanese era years, or Roman numerals for months, but any other combination you can think of was there. 600 records, took me several hours because the software is not exactly user friendly and I had to convert each date to its internal representation by hand.
After that, I force every single web form to use date pickers for date fields. But of course text fields are still a mess, maybe I will adopt your approach too ;)