Is it possible, i am sure it is. that i can us a combination of a getdate and datename within a query to be able to achaive a where command?
say that i have a query like this
Select col1, col2, col3
Where col1 = datename(MONTH,(getDate()))
I want to be able to always have the current month or year in the query with out having to pas the value into the query.