Query year from a DD/MM/YYYY field

J

Josh

easy question, I think:

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

thanks in advance,

Josh
 
R

Rick Brandt

Josh said:
easy question, I think:

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

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#
 
Top