RE: [ cf-dev ] Date manipulation n00b

[Damian Watson]

Title: Message

Sh$t, I thought I was joking…   -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Date manipulation n00b   If your on my list, i already have it... didn't u read the small print :-)     -----Original Message----- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:50 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Date manipulation n00b does that mean Russ can have your soul? -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:46 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Date manipulation n00b sweet   thanks Russ   ----- Original Message ----- From: Snake Hollywood To: [EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 3:44 PM Subject: RE: [ cf-dev ] Date manipulation n00b   where MONTH(date) = 3   Russ -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 26 May 2004 14:39 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Date manipulation n00b Select InvoiceID,invoiceName ,datecreated from tblinvoices where #datepart("MONTH",test.datecreated)# = 3     can someone tell me how to fix that so I only return records for the 3rd month of the year?      its eating my soul   thanks   |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|