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

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.7, 1.7.1, 2.6.1
    • BACKEND
    • Database SQL/XMLDB, Libraries
    • MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_26_STABLE
    • 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

          has a non-specific relationship to

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-19492 allow the date question to get dates older than January 1st, 1970

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-45058 Form date selectors should not offer far-future dates

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is duplicated by

          Improvement - An enhancement to an existing Moodle feature. MDL-5727 Database module dates limited to 1970 - 2020

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will be (partly) resolved by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-45058 Form date selectors should not offer far-future dates

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-52354 html_writer::select_time does not respect the calendar type plugin

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will help resolve

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-43717 Behat test failure on 32bit PHP

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              Unassigned Unassigned
              andreabix Andrea Bicciolo
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              8 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: