Date parsing issue "Month out of range"

[kescobo]

I've been running into a weird date parsing issue, and I can't sort out what the pattern is, though I've managed to nail down a MWE

The linked csv has 4 rows of dates.

julia> load("parse_test.csv") |> DataFrame
ERROR: ArgumentError: Month: 27 out of range (1:12)
Stacktrace:
 [1] Date(::Int64, ::Int64, ::Int64) at ./dates/types.jl:204
 [2] tryparsenext(::TextParse.DateTimeToken{Date,DateFormat{Symbol("yyyy/mm/dd"),Tuple{Base.Dates.DatePart{'y'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'m'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'d'}}}}, ::String, ::Int64, ::Int64, ::TextParse.LocalOpts) at /Users/kev/.julia/v0.6/TextParse/src/field.jl:431
 [3] macro expansion at /Users/kev/.julia/v0.6/TextParse/src/util.jl:23 [inlined]
 [4] tryparsenext(::TextParse.Field{Date,TextParse.DateTimeToken{Date,DateFormat{Symbol("yyyy/mm/dd"),Tuple{Base.Dates.DatePart{'y'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'m'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'d'}}}}}, ::String, ::Int64, ::Int64, ::TextParse.LocalOpts) at /Users/kev/.julia/v0.6/TextParse/src/field.jl:569
#...

(the stack trace is super long, let me know if it would be useful to post the whole thing)

There are 3 27s, two in the second row, and one in the last row. If I remove just the last row, it works.

julia> load("parse_test.csv") |> DataFrame
3×6 DataFrames.DataFrame
│ Row │ c1         │ c2         │ c3         │ c4         │ c5         │ c6         │
├─────┼────────────┼────────────┼────────────┼────────────┼────────────┼────────────┤
│ 1   │ 0016-08-08 │ 0011-11-10 │ 0016-08-08 │ 0010-01-15 │ 0010-01-15 │ 0016-08-08 │
│ 2   │ 0016-05-27 │ 0010-12-13 │ 0016-05-27 │ 0012-01-15 │ 0012-01-15 │ 0016-01-01 │
│ 3   │ 0016-06-15 │ 0011-08-04 │ 0009-12-21 │ 0011-01-09 │ 0011-01-09 │ 0009-11-24 │

julia>

But if I leave the 4th row in and just change the 27 in the last row to a 2, I get the same ERROR: ArgumentError: Month: 27 out of range (1:12).

If I change all the 27s to 2s, I now get ERROR: ArgumentError: Month: 21 out of range (1:12), and again this error goes away if I delete the last row, even though there are no 21s in the last row.

There's not just something weird with that row - this is part of a much larger csv file, and removing only row 4 does not stop the error.

[kescobo]

Just now looking at the output, I see it's taking the 2 digit years to be 0016 rather than 2016, which is a different problem I suppose...

[davidanthoff]

Can you try to load the file with TextParse.jl directly? That is the parsing package I use under the hood, and it would be good to narrow down whether this is a problem in CSVFiles.jl or TextParse.jl.

[kescobo]

Good call - looks like it's coming from there. Sorry about that, new issue: queryverse/TextParse.jl#69