Are both of them in same format Appt.date and $date1 i.e. dd/mm/yyyy. If not make them in same format (You can use DATE_FORMAT to convert the format of date). If they are in same format then if your Appt.date is a date filed then convert your $date1 into date by mysql cast method.
Enjoy,
Amit
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.On Wed, Jul 28, 2010 at 7:59 PM, james <jameslivsey@googlemail.com> wrote:
Hi, I'm using the datepicker widget to allow the user to enter dates
to filter by.
The query I build is
$filterAppts = $this->Appt->find('all',
array('conditions'=>array('Appt.date' => $date1),));
where $date1 is the date value passed back by the datepicker through
$date1 = $this->data['Appt']['date filter: Date 1'];
but it doesnt seem to be matching the dates. Is there some format that
I need to put them into before i can compare a date to the date field
in the database? Currently they are strings.
Many thanks!
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
No comments:
Post a Comment