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 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 W

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 and

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

RE: Pulling record for this month

2004-02-05 Thread Andrew Tyrone
Sent: Wednesday, February 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 A