Project

General

Profile

Actions

Bug #69287

closed

Can't enter years before 1902 in date-fields

Added by David Bruchmann about 9 years ago. Updated over 7 years ago.

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

0%

Estimated time:
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 2 (0 open2 closed)

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

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

Actions
Actions #1

Updated by Riccardo De Contardi about 9 years ago

  • Category set to FormEngine aka TCEforms
Actions #2

Updated by Riccardo De Contardi over 8 years ago

still reproducible on latest 8.2 master :(

Actions #3

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

Actions #4

Updated by Riccardo De Contardi over 7 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.

Actions

Also available in: Atom PDF