Forums

I have spent a couple of Hours to find a solution for my Problem,
but i cant find an answer.

I need to save a date in sql Datetime format, into the db.

My attempt now was to choose a datetimepicker, let CF create the table and se if it works.
it doesnt.

so how i configure Chronoform to save it as DateTime?
the only thing i get no matter what i input is a db enty with 0000-00-00 00:00:00.

Another Question that i have is what can i configure with all those fields in the edit Elements Settings?
is there a Documentation when yes where?

Thanks for help
Joachim

Hi Joachim.

When you create the table ChronoForms sets all the column types to VARCHAR(255) - change the date+time column to a type of DATETIME like the created column. Then make sure that the date-picker is creating a format that MySQL will recognise. Or use a Custom Code action before the DB Save to convert from a user friendly format to a computer friendly one.

Bob