Bug #69287

Can't enter years before 1902 in date-fields

Added by David Bruchmann over 6 years ago. Updated over 4 years ago.

Must have
FormEngine aka TCEforms
Target version:
Start date:
Due date:
% Done:


Estimated time:
TYPO3 Version:
PHP Version:
date-field, year
Is Regression:
Sprint Focus:


Trying to enter the Birth-Year (1879) of Albert Einstein the Year is set by JavaScript to 2015.

I never thought yet about a user-function or another way to work around this issue, but I'd prefer this issue being fixed instead of something else.

Related issues

Related to TYPO3 Core - Bug #37244: TCA date evaluation for dates lower 01-01-1970 failsClosed2012-05-17

Related to TYPO3 Core - Bug #79448: Handling dates in the very past inside T3-BackendNew2017-01-24


Updated by Riccardo De Contardi about 6 years ago

  • Category set to FormEngine aka TCEforms

Updated by Riccardo De Contardi over 5 years ago

still reproducible on latest 8.2 master :(


Updated by David Bruchmann over 5 years ago

To describe the problem a bit more:

  • the 1970-Problem with dates usually is JavaScript-related.
  • The datepicker from ExtJS (implemented in TYPO3, at least 6.2) can handle dates back to year 0.
  • MySQL-datetime can handle dates starting with year 1000. This general option was implemented by Xavier already.
  • The Datetime-functions of AdoDB can handle years back to year 0, with adjustments probably further back too.
  • Some databases can handle dates that go further back than 0, i.e. PgSQL can handle approximative -4500
  • Some PHP-Functions might limit the handling of dates too.

So the problem involves JavaScript, Database and PHP depending on how far you want to be able to go back.
I think a really cool approach would be to enable TYPO3 to take dates older than 0.
I planned working on it but never found the time yet and in the moment I never see any time-window in nearer future.


Updated by Riccardo De Contardi over 4 years ago

  • Status changed from New to Closed

I close this in favor of #79448 please continue the discussion there.
I've added there a reference to this issue and the latest comment to keep track of it.

Thank you.

Also available in: Atom PDF