DataAssist with Datepicker

I am using dataAssist and have a very simple insert form. One of the form inputs is a date and I chose to insert datepicker to assist in grabbing dates. The form and datepicker seem to work together fine, but the date chosen is not being sent to the database.

Can you help me?

can you send a copy of the page.

Hello

File is attached.

Good Friday!

Jon

1) The insert behavior is expecting the date to come from a form elemewnt named "date"

the date picker element is named "lou-ann-events" though:

<input id="datepicker_1" name="lou-ann-events" type="text" />

change the name to date:
<input id="datepicker_1" name="date" type="text" />


2) a date column in MySQL Expects the date to be in the yyyy-mm-dd format.

add the following code at ine 1 to reformat the date to the expected format:

<?php 

if(isset($_POST['date'])) { 

    $_POST['date'] = date("Y-m-d", strtotime($_POST['date'])); 

}

?>

Thank you

This works great now. I do have another issue. Once the data is submit via the insert form I am taken to the details page; which is fine. However, when I click the "Back to Results" button I am taken to the Results page where no information is listed. I am unable to edit or delete the data.

Please let me know if I need to submit another page for you to examine.

Thank you

Jon

send a copy of the results page please.

Here you go...

the results page recordset is set to filter on a date URL variable, there should not be a filter on the results page recordset.

What would be the safest way to remove that URL?

edit the recordset and remove the filter.