Strange Date Format Question

Hi,

I am trying to use datepicker to insert into MySQL database table into a date field

I changed this format in the code:

<script type="text/javascript">
$(function(){
$('#datepicker_1').datepicker({
dateFormat: 'yyyy/mm/dd',
showAnim: 'show',
onClose: closeDatePicker_datepicker_1
});
});
function closeDatePicker_datepicker_1() {
var tElm = $('#datepicker_1');
if (typeof datepicker_1_Spry != null && typeof datepicker_1_Spry != "undefined" && date_Spry.validate) {
datepicker_1_Spry.validate();
}
tElm.blur();
}
</script>

However, when it does not insert but when you select a date from the calendar, it shows up still in mm/dd/yyyy format even though in the code its changed; please advise?

1) That is an invalid date format. in the date picker API:

yy stands for a 4 digit year format. y stands for a 2 digit date formation

use:
dateFormat: 'yy-mm-dd',

2) changes to javascript may not be seen right away till you clear the browsers cache.

Ok I changed the date format and ran CCleaner to clear cache but still not working correctly.

When I go to update a record the date is still showing as 0000-00-00

And when I select a date from the calendar it shows as 09/05/2014

I'll need to troubleshoot directly, see the private message section.

Ok sent

viewing the source code for page shows the old date format.


it doesn't look like your changes are being uploaded to the server properly.

Thanks

I'll need to troubleshoot directly, see the private message section.

I think I got it thanks