Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Medium Medium
    • Resolution: Fixed
    • Affects Version/s: 3.6.1, 5.3-dev
    • Fix Version/s: 5.3
    • Component/s: Misc
    • Labels:
      None
    • Environment:

      Version: 3.6.1
      PHP Version: -
      Webserver: -
      Database: -

      Description

      As ezPublish stored date and datetime values using Unix timestamps, the user cannot enter a date before 1.1.1970.
      This is annoying, when you build a list of users with birth dates: "Young" persons can be stored, while persons of 35 years or older cannot have their birthday stored.
      Suggestion: Either provide a new datatype, which allows this or enhance the current datatype to support some kind of offset (possibly defined per attribute).
      So, if i define an offset of 70 years, the value "0" would define 1.1.1900, instead of 1.1.1970.
      I don't know the range of the unix timestamp values though, but it should at least be possible to store dates for a century or two.

        Issue Links

          Activity

          Show
          André Rømcke added a comment - Merged in https://github.com/ezsystems/ezpublish-legacy/commit/2eff97b7343102e6a9179e7f6b61d8a82c4f1355
          Hide
          Pedro Resende (Inactive) added a comment - - edited

          While testing this I've found out that ezdate datatype wasn't taken into account, I've create a new issue with this https://jira.ez.no/browse/EZP-22895 and a PR

          Show
          Pedro Resende (Inactive) added a comment - - edited While testing this I've found out that ezdate datatype wasn't taken into account, I've create a new issue with this https://jira.ez.no/browse/EZP-22895 and a PR
          Hide
          Pedro Resende (Inactive) added a comment - - edited

          I've found a problem, if you insert the date 9/12/1901 at 01:00 in a ezdatetime fieldtype after publishing the object the value will be changed to 13/12/1901 8:09 pm. I've created a new issue addressing this problem EZP-22898

          Show
          Pedro Resende (Inactive) added a comment - - edited I've found a problem, if you insert the date 9/12/1901 at 01:00 in a ezdatetime fieldtype after publishing the object the value will be changed to 13/12/1901 8:09 pm. I've created a new issue addressing this problem EZP-22898
          Hide
          Pedro Resende (Inactive) added a comment -

          Tested and approved by Q.A.

          Show
          Pedro Resende (Inactive) added a comment - Tested and approved by Q.A.
          Hide
          Joao Pingo (Inactive) added a comment -

          QA Approved

          Show
          Joao Pingo (Inactive) added a comment - QA Approved

            People

            • Assignee:
              Unassigned
              Reporter:
              Marco Zinn
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours
                5h