Query in SQL that allows wildcard month/day but specific year

Question

If i have a Date/Time field in Access and i need to find all the entries that are in a specific year... say 2009. If my fields are set up as MM/DD/YYYY, how would i do a query to essentially do //2009

update Thanks for the help everyone, but i guess the issue is that I'm kind of dynamically constructing my SQL statement in ASP.

"SELECT * FROM database WHERE (datecolumn LIKE " & string & ")" where the string ends up returning a string i constructed 'DD/MM/YYYY'. If the user inputs nothing into either of the 3 fields, i'll needa do a specific query where that part is a wildcard... as in if they don't put in a day, i'd essentially need a

"SELECT * FROM database WHERE (datecolumn LIKE "*/MM/YY")".... which doesnt work in microsoft access

Answer 1

OTTOMH

SELECT * FROM Table WHERE DatePart ("yyyy", YourDatetimeColumn) = 2009

Answer 2

How about

WHERE MyDate >= '1/1/2009' AND MyDate < '1/1/2010'

Answer 3

You should be able to use the Year() function

Some Examples:

Year (#05/05/1985#)      returns 1985
Year (#17/07/2005#)      returns 2005

If your field is called "myDate" for example, you can construct a query to select everything in the year 2009 like so:

SELECT * FROM myTable WHERE Year(myDate) = 2009

This function is available in both MS Access and SQL Server, too (if you're interested).

Some links for further information:

Access: Year Function
Year Function
YEAR (Transact-SQL)

Answer 4

WHERE Year(DateColumn) = 2009