JT
-----Original Message-----
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 11:43 AM
To: CF-Talk
Subject: RE: Pulling record for this month
You need to do:
and month(date) = #month(thismonth)#
Steve
-----Original Message-----
From: JT [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 1:41 PM
To: CF-Talk
Subject: Pulling record for this month
How can I pull all records where date = this month. this is what I have
and
it is not working?
Which month is it
<cfset thismonth = #now()#>
And then I query using this query .
select * from tablename
where completed = 1
and date = #DatePart("m", thismonth)#
order by date,time
There are 7 record but it pulls 0 records
What am I doing wrong?
Thx ,
JT
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
