RE: Simple Query Help

2003-02-05 Thread Robertson-Ravo, Neil (RX)
Yep you are... >> WHEREDatePart(,EventDate) = AND DatePart(,EventDate)= This will not work... the first part of the Where clause needs to be something like WHERE EventDate >= '[YOURDATE]' I am not sure what format your date is in, but I think you get the idea :-p

Re: Simple Query Help

2003-02-05 Thread Jochem van Dieten
SELECT Title, Details, EventDate, StartHour, StartMin FROM Events WHERE EXTRACT (YEAR FROM EventDate) = AND EXTRACT (MONTH FROM EventDate) = ORDER BY EventDate ASC Jochem ~~

RE: Simple Query Help

2003-02-06 Thread Kennerly, Rick H CIV
You're one fine CF man. Thanks. Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 05 February, 2003 10:45 To: CF-Talk Subject: Re: Simple Query Help SELECT Title, Details, EventDate, Star

RE: Simple Query Help

2003-02-06 Thread Kennerly, Rick H CIV
I see said the blind man. Thanks for the assist! Rick -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 05 February, 2003 10:38 To: CF-Talk Subject: RE: Simple Query Help Yep you are... >> WHEREDatePart(,EventDate) = ??

Re: Simple Query Help

2003-02-06 Thread Stephen Moretti
an integer. Regards Stephen - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 2:45 PM Subject: Re: Simple Query Help > > SELECT > Title, > Details, > E