I´ve solved this type of issues with a hidden field having the value in sql format (YYYY-MM-DD ) and formatting the date for user with php in the text field. ( http://php.net/manual/en/function.date.php )
jquery can set 2 fields with the diferents formats. ( http://jqueryui.com/datepicker/#alt-field ) El martes, 6 de mayo de 2014 11:00:32 UTC-3, Dario Savella escribió: > > I was able to make this work without much of a problem using dates in the > format they arrive from the database. > But that's not an acceptable for the users... and here I started having > problems. > > It's easy enough to set the dateFormat of the datepicker (as suggested in > posts I've seen around), but that does not seem enough. > When editing a row, dates are still displayed in ISO format and modified > ones, that have been returned with the correct format by the datepicker, > are not understood by the Model/MySQL that ends up saving the row with > messed up values. > I build the field with: > echo $this->Form->input('date_start', array( > 'type' => 'text', > 'class' =>'datepicker', > 'size' => 10 > )); > > Before I start writing an Helper (that perhaps generates an hidden field > with the date in ISO format and the necessary Javascript to move the > displayed value to&from and reformatting as necessary)... > > I was wondering if there's a better solution around I just have not seen... > > Can anyone help ? > > Dario > > -- 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.