[ cf-dev ] Date manipulation n00b

[Matt Horn]

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