RE: Pulling record for this month

2004-02-05 Thread Andrew Tyrone
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

Pulling record for this month

2004-02-04 Thread JT
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

RE: Pulling record for this month

2004-02-04 Thread DURETTE, STEVEN J (AIT)
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

RE: Pulling record for this month

2004-02-04 Thread Bryan F. Hogan
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

RE: Pulling record for this month

2004-02-04 Thread JT
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