Hello James, 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 On Wed, Jul 28, 2010 at 7:59 PM, james <[email protected]> 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 [email protected] > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
