Datepicker and inserting to DB

[eluser]jonez[/eluser]
If you're getting an error on the insert (incorrect date format), format the date to match the field in your database. If it's a datetime field, do this:

Code:

'fromDate' => date( 'Y-m-d H:i:s', strtotime( $this->input->post('fromDate') ) ),

Or if it's just a date:

Code:

'fromDate' => date( 'Y-m-d', strtotime( $this->input->post('fromDate') ) ),

When you read the value back out it will be in the database format, so to turn it back into your field value use the same method and adapt the date parameters: http://php.net/manual/en/function.date.php