Insert DatePicker Values

Could someone please explain to me how to insert the date into mysql using the DatePicker?

I built a form using FormBuilder which includes the DatePicker but, I'm unsure how to code the DatePicker to insert the date into the database. I tried using the php value from the form with no success.

<?php echo((isset($_POST["Date_Picker_Select_A_Date_field"]))?$_POST["Date_Picker_Select_A_Date_field"]:"") ?>

I don't know php all that well, and I'm not sure what steps I need to take next to insert the date correctly into mysql. Would someone please point me in the right direction?

Thank you.

First, make sure that your date column data type is set to date and then in your form we need to change the format of the date to look like this 'yyyy-mm-dd'.

In DW look for these lines of code:

changeMonth: true,
changeYear: true,

and change it to:

changeMonth: true,
changeYear: true,
dateFormat:'yy-mm-dd',


And then on the bottom of the page change the spry validation from:

format:'mm/dd/yyyy'

to

format:'yyyy-mm-dd'

Thank you very much, Dani.

I got the forms working thanks to your code suggestions--that saved me a lot of time spent in trial and error.

Two more Questions:
1) Is there any information or tutorials somewhere describing how to integrate/convert/update DataAssist forms with FormBuilder forms? I could definitely use some basic step-by-step instructions detailing how to accomplish this task.

2) Can the DatePicker be configured to work on search forms to search by date? If so, how?

Thanks again for your help.

Have a look here:

modifying_custom_form.pdf

Thanks for the link to the Modifying an Existing Form pdf. I had read the information before, but I guess not all of it had sunk in.

However, I must still be doing something wrong because after I attach the insert behavior to the new FB form, the php seldom works between the pages and requires a lot of fiddling to get the pages working again. Names between the DA and FB pages don't seem to match up, and I'm often unsure what needs to be changed where, to get pages working again.

Does anyone have any tips for building a form with FB where the php works right the first time with other DA forms or is it just me that has this problem?

Also, can the DatePicker be configured to work on search forms to search by date? If so, how?

When I use the DatePicker in a search form, the form returns all results and not results for a specific date. Using DatePicker, what settings should I use in the DASearch Server Behavior configuration to search by date or between dates?

Thanks for any help and advice.

Could you please give me an example of how the Form Builder form is not working with the DA insert server behavior. You should have to change any thing on the form or the Server Behavior to get the insert to work. If there is a problem that could see and i will be more than happy to help you.


In regard to the search, have you changed format to a UK format already?

If yes, that could be part of the issue.