Re: compare dates query

Thanks Amit,

I have no idea what I had set wrong but it seems to be working as it
should now with no alterations from me.. Maybe the remote app just
needed a bit of time to catch up..

Many thanks for your reply!!

On 28 July, 15:36, Amit Rawat <rawatami...@gmail.com> wrote:
> 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 <jamesliv...@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 sitehttp://cakeqs.organd 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<cake-php%2Bunsubscribe@googlegroups.com>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 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