Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-9046

Database date field does not allow entering date before 1970 or after 2038

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7, 1.7.1, 2.6.1
    • Fix Version/s: BACKEND
    • Labels:
    • Affected Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_26_STABLE
    • Workaround:
      Hide

      Upgrade to 64bit OS, DB, Apache and PHP.

      Show
      Upgrade to 64bit OS, DB, Apache and PHP.

      Description

      Currently Data Field created in teh databases allow only years from 1970 to 2020.
      While in most cases the year before 1970 or after 2020 aren't used, there could be situations where it is needed to enter a wider (or even narrower) range of year.

      A very good improvement would be allowing teacher to set the year date range that would appear in the year drop down boxes when a Date Field is created: in such a way the year range could be both set for narrower or wider needs.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              andreabix Andrea Bicciolo
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              8 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: