I followed the instructions and it works. The problem is when I try to save it to database (MySQL) where it expects date in 'YYYY-mm-dd' format while I set it to be displayed in 'dd/mm/yy' format in the form. So, I insert codes to change the format as expected by mySQL in beforeSave function in the model as below:
$this->data['Posttest']['submit_date'] = date('Y-m-d',strtotime($this->data['Posttest']['submit_date'])); In add view, it works perfectly. But in edit view, the date is still displayed in 'YYYY-mm-dd' format. On Saturday, December 27, 2014 at 4:07:09 AM UTC+7, Sandeep Kumar wrote: > > Thank you Florin Trifu for your answer, it saved a lot of time.. > > I made some changes to script to include date format to hope that helps > someone else > > <script> > $(function() { > $(".datepicker").datepicker( > { > dateFormat: 'yy-mm-dd', > onSelect: function(dateText, inst){ > $('#select_date').val(dateText); > $("#datepicker").datepicker("destroy"); > } > } > > > ); > }); > </script> > > > > > > On Wednesday, November 30, 2011 4:11:27 AM UTC+4, Florin Trifu wrote: >> >> Thank you very much! Indeed it worked. >> >> Just to let the other users know in case they will have the same problem: >> >> 1. Download jquery (http://docs.jquery.com/Downloading_jQuery) and put >> the file in $project/app/webroot/js (e.q: >> *$project/app/webroot/js/jquery.js*) >> 2. Download jquery-ui (http://jqueryui.com/download); I, for example, >> downloaded a zip archive called: jquery-ui-1.8.16.custom.zip. From this >> archive you will have to copy the followings: >> >> a. *$archive_root/js/jquery-ui-*.js* in *$project/app/webroot/js* (give >> it a shorter name e.q: jquery-ui.js) >> b. *$archive_root/css/smothness/** to *$project/app/webroot/css* >> (including the images; rename the css file to something shorter) >> >> 3. Include both js files in your layout. eq: >> >> >> >> >> >> >> *//$project/app/views/Layouts/default.ctp-------------------------------------------------------------echo >> >> $this->Html->script(array('jquery', >> 'jquery-ui'));*4. Include the css file. Eq >> >> >> >> >> >> *//$project/app/views/Layouts/default.ctp >> -------------------------------------------------------------echo >> $this->Html->css('jquery-ui.css');*5. Put this lines of code before >> calling the date-picker: >> >> >> >> >> >> *<script>$(function() { $("#datepicker").datepicker();});</script>* >> >> 6. Call the date picker in your form: >> >> >> >> >> >> *echo $this->Form->input('expire', array( >> 'id'=>'datepicker', 'type'=>'text' )* >> >> This is it! >> >> Best regards! >> >> >> -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.