compare dates query

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