Query year from a DD/MM/YYYY field

[Guest]

easy question, I think:

want to query all 2004 entries from a DD/MM/YYYY field in a table

thanks in advance,

Josh

 

[Guest]

Try this query

Select * from MyTable Where year(MyField)=2004

 

[Rick Brandt]

easy question, I think:

want to query all 2004 entries from a DD/MM/YYYY field in a table

Please explain first what a DD/MM/YYYY field is. Is it a text field that
happens to contain strings formatted like that to represent dates or is it
an actual DateTime field? The query would be quite different depending on
the answer to that question. Keep in mind that if its an actual DateTime
field the formatting is irrelevent to writing your query.

If it's a Text field...

SELECT * FROM TableName WHERE FieldName Like "*2004"

If it's a DateTime field...

SELECT * FROM TableName
WHERE FieldName BETWEEN #2004-01-01# AND #2004-12-31 23:59:59#