you could try:
Select InvoiceID,invoiceName ,datecreated from tblinvoices where
datepart(month, datecreated) = 3
hth
----- Original Message -----
From: "Matt Horn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 26, 2004 2:38 PM
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]
|\--------------------/|
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
