Date storage issue

I have insurance dates that are formated to appear by PHP to appear DD-MM-YYYY
this form info needs to be stored with an order (summary)

Opening the store Cart Summary SB (view columns against values)
and checking the DB Column InsuredPolicyExDate - I get type text
the DB field it refers to is type DATE

I set the field to date - but this is never saved and it reverts to TEXT?
and I just get a blank entry 0000-00-00 in my order

AS a last resort I set it to MSDATE (which stuck - but I get a MYSQL error on insert)

Is this the SB interface not working correctly

Note: There's obviously no way for the cart to know the format of the date is
Suggest this feature is added to the cart general settings - page 1


I need a way to get from the human readable
DD-MM-YYYY
php formatted display date

back into the correct format for the summary insert

if the text is entered
DD-MM-YYYY

then
// convert back the dates to mysql format

//list($d,$m,$y) = explode('-',$_SESSION['insure_date']);
//$_SESSION['insure_date'] = $y."-".$m."-".$d;

//list($d,$m,$y) = explode('-',$_SESSION['health_date']);
//$_SESSION['health_date'] = $y."-".$m."-".$d;

seems to do the trick if I echo it directly to the page to check it visually

but I still get 0000-00-00 in my database insert?

please advise

i had a similar thing recently with the datpicker extension.

take a look at this thread, you could modify the function to suit your needs...

showthread.php?t=17864

(Thanks to Dave Buchholz for the idea)

Also see thread showthread.php?t=9484&page=2

Thanks guys

A combination effort got things working


2 Things

1/
Still looks like there's a bug in the ecart 5.01 interface
I can't set the datatype to DATE only TEXT NUMBER or MSDATE in the SUMMARY to DATABASE SB

most odd


2/
Date formatting should be in the general settings in the Cart setup first tab

In MySQL, a string and date are treated the same. a date is passed the same as a text string in my sql:
'text string'
or
'2011-5-2'


you can get around these date formating issues by using a varchar columns for your dates, a MySQL date column will need to use the yyyy-mm-dd hh:mm:ss format

in a varchar column you can store the more familiar 5/2/2011 format. If you are going to use a data column type, then you will need to reformat the date to the expected format.