[#39704] - JForm XML Calendar Field (date only) in Greek Backend
- Closed
- 25 Jan 2023
- Urgent
- Build: 4.2.6 Release Version
- # 39704
Steps to reproduce the issue
- There is component com_xxx;
- There is a Joomla XML Form for some model in that component;
- There is a calendar field with the following settings in that XML form:
3.1 showtime="false" (The developer wants to use this field only for date info);
3.2 translateformat="true" (it will use the global language parameter DATE_FORMAT_CALENDAR_DATE); - set Joomla backend language to Greek, its default date format is %d-%m-%Y;
- edit an item from that model;
- select a date "13-07-2013" (greek format) for the date field mentioned above;
- save.
Expected result
"13-07-2013" should be saved successfully, in sql database will be "2013-07-13"
Actual result
Either a fatal error will happen or a completely different date will get saved in database.
System information (as much as possible)
Joomla 4.2, PHP 8
Additional comments
Similar issue happens by the usage of custom field com_fields with a calendar field (date ony) in greek backend.
The issue doesn't happen in greek backend if the calendar field is set with:
- showtime="true";
- translateformat="true".
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
Yes by changing the value of DATE_FORMAT_CALENDAR_DATE to the english format, it will work, but it doesn't match the interests of a greek user. It is just a workaround.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/39704.
In my comment I posted a constants with default value, you have to change them to your format.
Changing both DATE_FORMAT_CALENDAR_DATE and DATE_FORMAT_FILTER_DATE they should be in sync.
Thank you very much! Indeed the error came from the official greek language package:
DATE_FORMAT_CALENDAR_DATE="%d-%m-%Y"
DATE_FORMAT_FILTER_DATE="y-m-d"
I corrected DATE_FORMAT_FILTER_DATE to "d-m-Y", everything works like a charm.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/39704.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2023-01-25 09:27:15 |
| Closed_By | ⇒ | liuvz |
Make sure you edit both DATE_FORMAT_CALENDAR_DATE and DATE_FORMAT_FILTER_DATE.
Check this comment #37000 (comment)