moissinac / csvfix

Automatically exported from code.google.com/p/csvfix
MIT License
0 stars 0 forks source link

date_iso doesnt format correctly a 9999 year #68

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.Change data/birthdays.csv so that the first line reads
"Peter","20/8/9999"

2. run the example on the manual:
csvfix date_iso -f 2 -m 'd/m/y' data/birthdays.csv

3. It doesn't format the first line:
"Peter","20/8/9999"
"Jane","1970-02-12"
"Bill","1971-06-14"
"Anna","1976-12-27"

What is the expected output? What do you see instead?
"Peter","9999-08-20"
"Jane","1970-02-12"
"Bill","1971-06-14"
"Anna","1976-12-27"

What version of the product are you using? On what operating system?
1.5 on windows

Please provide any additional information below.
I think the ISO standard allows years up to 9999.

Original issue reported on code.google.com by under...@gmail.com on 6 Jun 2013 at 10:36

GoogleCodeExporter commented 8 years ago
The CSVfix date_iso command currently only deals with years in the range 1900 
to 3000. I will investigate if the range can easily be extended. If it cannot, 
I'll document the limitation, and issue an error message if a date is outside 
that range.

Original comment by nbutterworth1953@gmail.com on 7 Jun 2013 at 8:38