Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › CSS Form Builder › Date Picker CSS Form Builder Inserts 0000-00-00 00:00:00

Date Picker CSS Form Builder Inserts 0000-00-00 00:00:00

Thread began 1/31/2010 4:39 pm by dlovas275157 | Last modified 1/10/2012 11:33 am by dlovas275157 | 9137 views | 10 replies

1/31/2010 4:39 pmdlovas275157

Date Picker CSS Form Builder Inserts 0000-00-00 00:00:00

I have implemented the Date Picker via the CSS Form Builder. The datepicker appears in the form as needed, however when the record is inserted into my database, the datetime field is "0000-00-00 00:00:00" instead of the proper date such as "2009-08-20 10:40:43".

Below are the steps I followed:
1. Create insert.php form via DataAssist Wizard.
2. Take insert.php form into CSS Form Builder and edit the form so dateCreated field has a datepicker instead of textfield. Apply CSS Design, and Finish wizard.
3. Edit Insert Record SB in the SB Panel so the form fields are binded to the values from the new recordset created by the CSS Form Builder wizard, instead of binded to the original recordset.
4. Test form. Inserting record fully works accept the dates as noted above.

My date fields in my database are formatted at datetime YYYY-MM-DD hh:mm:ss and must stay this way for other reasons. Example entry: 2009-08-31 11:54:00

Maybe this is related to validation?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.