datepicker format

i have added a datepicker to my dataassist, wizard created insert record page, to replace the standard date field.

i would like to format the date field so that it reads dd/mm/yyyy on screen, but is saved as yyyy-mm-dd for insertion in my mysql database.

if i choose dd/mm/yyyy in my datepicker properties, no date value is inserted

Craig,

use this function and wrap the date in the insert behaviour with it

function i8_formatUKDateMySQL($date) {

$d = str_replace(" ","",$date);

$d = explode('/', $date);

$d = $d[2].'-'.$d[1].'-'.$d[0];

return $d;

}

Thanks for the function Dave, it works a treat.

Much appreciated.



...But should the extension be able to do this out of the box ?

Craig,

DataAssist, which I am assuming you are using, handles US style dates out of the box but for UK style dates I have always had to use an external function.

Hi Dave.

Yeah, I'm aware of the US centric thing, its just that I was under the impression that all dates saved to a MYSQL database table were saved as YYYY-MM-DD format anyway.

i hoped that choosing the format on the wizard would change the date format for the screen view, but the save format would remain.

No it doesn't work like that, there is a function as part of the data assist helper file that converts US dates as a matter of course but it doesn't work on uk dates

I didn't know that.

I'll take a look.

Thanks again

On my confirm.php page on my ecart based site, i have added a datepicker for the customer to select a date.

the date is formatted on the page as mm-dd-yyyy

the date value is stored as a session variable, and is required as part of the 'eCart store cart summary in database' server behavior.

However the date is in the wrong format to store in the database natively.

is it necessary to reformat the date by hand coding ?

(not difficult to do, but is there another way with US format dates)

Yes, you will need to use hand coding to convert the date to the format that us expected by he database.

thanks Jason.

i'm creating a nice set of 'useful' functions