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
SELECT
Title,
Details,
EventDate,
StartHour,
StartMin
FROM
Events
WHERE
EXTRACT (YEAR FROM EventDate) =
AND
EXTRACT (MONTH FROM EventDate) =
ORDER BY
EventDate ASC
Jochem
~~
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
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) = ??
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
5 matches
Mail list logo