Dates not automatically parsed if they can be integers #1040

Activity

1. quinnj commented on Oct 21, 2022

   

   quinnj

   on Oct 21, 2022

   Member

   More actions

   Hmmmm.....I've always been pretty hesitant to do anything like this, since we then open ourselves up to the problem Excel has (which is now the subject of many memes). i.e. the problem becomes someone has a valid int like 20190102 that we say is a Date and now they have to figure out how to go back to an int.
2. DylanModesitt commented on Oct 21, 2022

   

   DylanModesitt

   on Oct 21, 2022

   Last edited by DylanModesitt

   ContributorAuthor

   More actions

   Ha -- fair enough. Since these styles are not ISO8601, they wouldn't be parsed as dates unless the passed dateformat implies them to be. Of course, then there is some other 8-digit integer column that's not a Date and the meme is fulfilled.

   I think it would be nice to include this in the docs for dateformat= though since it could be slightly surprising. Alternatively, we could warn the caller that their dateformat may not be used by default if it would match continuous digits. Good to close this regardless.
3. nickrobinson251 commented on Oct 21, 2022

   

   nickrobinson251

   on Oct 21, 2022

   Last edited by nickrobinson251

   Collaborator

   More actions

   In this case, you can use the types keyword to request the column be a Date e.g.

   julia> file = file = CSV.File(IOBuffer(data); dateformat="yyyymmdd", types=Dict(:date => Date))
   2-element CSV.File:
    CSV.Row: (code = 0, date = Date("2019-01-01"))
    CSV.Row: (code = 1, date = Date("2019-01-02"))
    
   julia> file.date
   2-element Vector{Date}:
    2019-01-01
    2019-01-02

   Thanks for opening the issue - we'd definitely take a PR adding this as an example in the docs!

   ---

   p.s. We've also recently been discussing possibly in the future supporting an API something like file = CSV.File(x; types=Dict(:date => Date(dateformat="yyyymmdd")) so the type (Date) and the related parsing info (dateformat) would/could be passed together rather than separately... but that's not how things are currently. (cc @Drvi, re the TypeConf-idea becoming public API)

   👍React with 👍1Reacted by g-gundam
4. nickrobinson251

   added

   documentation

   on Oct 21, 2022
5. quinnj commented on Oct 15, 2026

   

   quinnj

   on Oct 15, 2026

   Member

   More actions

   [comment generated via AI] Documented in #1042 (now on main): numeric inference runs before a custom dateformat, so pass types=Dict(:date => Date) for digit-only dates. Checked on main with Julia 1.12: 20190101 infers Int64 with only dateformat="yyyymmdd" and parses as Date with the types entry.
6. quinnj

   closed this as completedon Oct 15, 2026