Bug #69287

Can't enter years before 1902 in date-fields

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

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
FormEngine aka TCEforms
Target version:
-
Start date:
2015-08-24
Due date:
% Done:

0%

TYPO3 Version:
6.2
PHP Version:
5.5
Tags:
date-field, year
Complexity:
Is Regression:
No
Sprint Focus:

Description

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 fails Accepted 2012-05-17
Related to TYPO3 Core - Bug #79448: Handling dates in the very past inside T3-Backend New 2017-01-24

History

#1 Updated by Riccardo De Contardi about 4 years ago

  • Category set to FormEngine aka TCEforms

#2 Updated by Riccardo De Contardi over 3 years ago

still reproducible on latest 8.2 master :(

#3 Updated by David Bruchmann over 3 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.

#4 Updated by Riccardo De Contardi over 2 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