Skip to content

Date field cannot accept older dates #3556

@robinsowell

Description

@robinsowell

If you put a date with year 1901 or older in a date field- including entry date- it won't validate and you can't save it.

Summarizing: You can't have dates prior to 1901 or after 2038. This is the size limitation of int data types that we use for date columns.

2 possible solutions:

  • allow changing column type from int to bigint same as we do for RTE fields. This is quick and easy, because we have the code already
  • start using datetime column instead of int for dates. This is IMO the most proper solution and this how it should have been done 15 years ago, but making the change will be more involved.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Bug: AcceptedBug has been confirmed, is reproducible, and ready to work on.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions