04, 2004 1:51 PM
To: CF-Talk
Subject: RE: Pulling record for this month
Thanks STEVEN that worked like a charm... i guess I need a brain dump
JT
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 11:43 AM
To: CF-Talk
Subject: RE
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
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
what is the values that are stored in the data column and what is it's
datatype?
-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
Thanks STEVEN that worked like a charm... i guess I need a brain dump
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
5 matches
Mail list logo