Bug #63081
closed
Setting [SYS][ddmmyy] does not change format of date in extbase extensions flexform
0%
Description
f.e. setting
[SYS][ddmmyy] f.e. to "d.m.Y"
in the install tool
does not change the format of date in the flexform of an extension with starttime, endtime fields.
The format of the date textfield left to the calendar is allways H:i d-m-y
Updated by Riccardo De Contardi over 8 years ago
It seems still present on 7.6.1-dev (latest master). What should that settings do?
Updated by Riccardo De Contardi over 8 years ago
- Category set to Backend User Interface
It seems still present on 7.6.1-dev (latest master). What should that settings do?
Updated by Susanne Moog about 4 years ago
- Status changed from New to Closed
This is by design. TCA (and by inheritance FlexForms) dates are documented with:
The field will evaluate the input as a date, automatically converting the input to a UNIX-time in seconds. The value stored in the database will be in UTC! That means that any input in the Backend will be treated as a local time (default timezone is either set by PHP configuration or in the Install Tool), but will be stored in UTC. The display will be like “12-8-2003” (assuming UTC+2) while the database value stored will be “1060639200”.
see https://docs.typo3.org/m/typo3/reference-tca/master/en-us/ColumnsConfig/Type/Input.html#id25
The setting basically only changes how TYPO3 displays "static" dates.
The only setting relevant to displaying dates in form is "USdateFormat" which switches between HH:mm MM-DD-YYYY and HH:mm DD-MM-YYYY.