CF8 - Text field as date and no data from database

Load a database date into a ChronoForms text field set as a date input.

Overview

The HTML5 date input type requires the YYYY-MM-DD format, but the stored date was in DD.MM.YYYY format.
Change the date format in your database to YYYY-MM-DD, or use a custom Calendar field type instead of the text field with a date input type.

rb rbock 17 Sep, 2023

Good morning...

I have defined a text field as a date in CF8. However, the value from the database is not loaded here. But as a normal text field. What can I do?

Max_admin 21 Sep, 2023

what about the format of the date ? you need to adjust some field attributes I think

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

rb rbock 22 Sep, 2023

Textfield: Input Type = Date

Database Field: varchar(10) = 01.01.2009 -> Not work
Database Field: varchar(10) = 2009-01-01 -> work

I need 01.01.2009

Apparently it works as a date field. But here I can't enter a date by hand.

Max_admin 25 Sep, 2023

Answer

I found online that the format is not changeable in the HTML5 date field, so you are restricted to the default format, unless a custom input is used, which is the Calendar field

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.