Filtering between two dates!!!!!!!!!!!

[jnpeanut]

I need to write a query that will find all of the dates from 2004. The field is in this format. (01/01/04)

This is what I tried but did not work
where fdd/date > #12/30/03# and fdd/date < #01/01/05#

Not only did this return no data but threw some of the code into the next blank field. (in design view)

Can someone help on this

Thanks

 

[FoFa]

What about: Year([MyDateColumn]) = 2004

 

[neileg]

Why not:
WHERE [fdd/date] Between #1/1/2004# And #1/1/2005#

Two points:
1) Days start from midnight. So if you use Dec 31 as the start, you'll include any records from Dec 31
2) I'm nervous about using fdd/date as a field name since it includes both a reserved word and punctuation that make it look like a formula. FddDate would be much better.

 

[Pat Hartman]

Between includes both end points. If you want records for a single year, you need to use
WHERE [fdd/date] Between #1/1/2004# And #12/31/2004#

Or

Where Year([ffdd/date]) = [enter year] ' to choose a specific year

or

Where Year([ffdd/date]) = Year(Date()) -1 ' to always choose the previous calendar year