Hiya
I have a web to lead form on a website of mine where a user can choose a date for an event. However, the jscalendar parses the date as USA format: month/day/year whereas I am from the UK
I've tried to change the %m/%d/%Y to %d/%m/%Y in both instances above but sugar won't save this correctly to the database, instead saving it as 00.00.00 and therefore an empty record.Code:<input onblur="parseDate(this, '%m/%d/%Y');" class="field3" name="bookingdate_c" size="12" maxlength="10" id="bookingdate_c" value=""> <img src="sugarcrm/themes/default/images/jscalendar.gif?c=1" src="sugarcrm/themes/default/images/jscalendar.gif?c=1" alt="Enter Date" id="bookingdate_c_trigger" align="absmiddle"> <script type="text/javascript"><!-- Calendar.setup ({ inputField : "bookingdate_c", ifFormat : "%m/%d/%Y", showsTime : false, button : "bookingdate_c_trigger", singleClick : true, step : 1, weekNumbers:false }); // --></script>
Could anyone help me? Any help will be greatly appreciated. Thanks!


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks