Select by Date?

[angst]

Hi,
I'm trying to do a select by date,

my query:

SELECT o.FOB,o.Customer_PO,o.id as oid,o.SON,o.Inv_Num,o.InvDate,o.SalesRep,o.Notes,a.username,a.id,o.FormType,a.username,ca.id as cid,o.BillTo,ca.Nickname FROM orders o,admin a,contacts_addresses ca WHERE ca.id = o.BillTo AND o.SalesRep = a.id AND Year(InvDate)=23 AND Month(InvDate)=01 AND Day(InvDate)=2006 ORDER BY o.InvDate ASC


shouldn't this work?
Year(InvDate)=23 AND Month(InvDate)=01 AND Day(InvDate)=2006

I thought it would, but i guess not,
could someone please show me what I'm doing wrong?

thanks in advance for your time!
-Ken

[angst]

oh duh!!

I had my array values mixed up from the Split,
had year and day reversed,

this is better:-)

Year(InvDate)=2006 AND Month(InvDate)=01 AND Day(InvDate)=23