Bug #63081
closed
Setting [SYS][ddmmyy] does not change format of date in extbase extensions flexform
Added by Christof Hagedorn over 9 years ago.
Updated about 4 years ago.
Category:
Backend User Interface
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
It seems still present on 7.6.1-dev (latest master). What should that settings do?
- Category set to Backend User Interface
It seems still present on 7.6.1-dev (latest master). What should that settings do?
- 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.
Also available in: Atom
PDF
Updated by 
Updated by