Calendar in Chronoforms are not saved in the mysql database

Hello,

I have a form where 12 elements are captured including a calendar date (format YYYY-MM-DD). the MySQL column is of date type. Every other form value is correctly captured in the database, but the calendar. It is a required field and not disabled. The form value in the debug shows the value is coming in empty, so this may be that form is not sending to DB.

Can you please let me know if I am missing anything?

Hi 4Summit,

The latest update had a new calendar "Real format" setting, that's the format which is going to be actually passed, what do you have there ?

Best regards,
Max

The real format is YYYY-MM-DD. I removed the time.

So now its working as it should ?

Best regards,
Max

Hey Max, No it is still broken.

I have tried many different formats, but not sure what is the right Chronoform format for MySQL Date column.

Interesting, Connectivity is working fine for that column as a calendar (y-m-d) format, but chronoforms does not.

Hi 4Summit,

What is the value shown in he debug after the form is sent at the moment ?

Best regards,
Max

There is no value (empty) shown the debug.

Hi 4Summit,

I have just tested and it works fine, please send me a screenshot of your calendar settings.

Best regards,
Max

Attaching the screenshot for calendar settings. Thanks for checking. I must have done a mistake and not able to find it.

Hi 4Summit,

Sorry for the late reply, just copy the string in the "Display format" into the "Real format" box.

Best regards,
Max

Hey Max,

The calendar date was after the dynamic drop downs and i moved it before the dynamic dropdown (in the page) and then it started working. This issue is only with the calendar coming after a dynamic dropdown (from the DB) - regular text fields and normal dropdowns are not impacted.

Thanks,
Srini

Hello Max, This issue is solved. When i changed the display and real format to YYYY-MM-DD, it started working. Thanks for your help!