Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

Problems with the European date format DD.MM.YYYY

ChronoForms v8
Pe
Peter48 21d ago

Problems with the European date format DD.MM.YYYY

Chronoforms8 offers the option of entering a date using the "Calendar" format. The input data can be defined as follows:

Display Format: DD.MM.YYYY (Example: 09.04.2025)

Stored Format: DD.MM.YYYY (09.04.2025)

Saving in the data table (text field) works correctly.

However, when reading the date, the day and month are swapped (see the example above: 04.09.2025 instead of 09.04.2025).

If the stored day does not correspond to a value between 01 and 12, an error message appears.

Example: 21.01.1948

Max_admin
Max_admin 21d ago
Answer

Hi Peter

You should always try to store the date in the mysql date format, this ensures the date is parsed later correctly in the field or anywhere else, you can easily use the built in {date:value format} to format it in a different format

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Pe
Peter48 20d ago
1 Likes

Hello Max

Thanks for the reply.

Since saving the date field in MySQL format (YYYY.MM.DD) sometimes involves additional effort for reformatting in SQL reports, I decided to display the date fields as text fields with a mask.

Best regards

You need to login to be able to post a reply.