UNABLE TO UPDATE DATABASE WITH CORRECTLY FORMAT DATE YYYY-MM-DD

looked though forum posts, tried several of the solutions suggested without success can you help please


dbmReviews_update

datepicker used
can get it to display dd/mm/yyyy ok
field initially null
trying to update date yyyy-mm-dd so sorting works correctly all it puts in is 0000 -00-00

Your update server behavior has the data type for the date field set to be number. Set it to date and the formatting should be done properly to allow the insert and updates to take place.

PLEASE HOW DO U. DO THAT, I DONT WANT TO CAUSE PROBLEMS

Double click on the insert or update server behavior. Then click the second tab to update the column bindings. Select the date column and choose "Date" from the column type list below.

done that

UPDATE: format looks ok indatepicker
DETAIL: date shoes as 1/1/1970 ur year shown a s -0001

IJUST CANT WORKIT OUT.. I SUSPECT ITS SOMETHING SO SIMPLE I HAVE FORGOTTEN TO DO

HELP!!!!

The Submit as value for that column is still set to "Double"... it has to be updated to "Date"

6found corruption an live site ,deleted and r=uploded agin still living problems

Highlight the column you are updating and see what is displayed in the "Save As" list below. It should be set to "Date".

c pm

This is about the Update server behavior and the data type that you are submitting. On the page it is set to a double, but you want to submit a Date.

1) Open up the update server behavior
2) Select the date column that isn't updating properly
3) Choose "Date" from the Save As select list on the bottom of that page
4) Click OK to save your changes
5) Upload the page to your site

If you still have issues, please attach the actual .php page to your reply to this thread and I can open it with Dreamweaver directly. Please mention the column name you are looking at so I can be sure we are looking at the same thing.