RE: [ cf-dev ] Date manipulation n00b

[Peter Harrison]

Title: Message

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] |\--------------------/|