Filter by Date

[Guest]

Hi,

I have a database where I need to filter out birthdays or anniversaries to
send out cards. They are formatted as mm/dd/yyyy. We will be sorting the
whole month at the beginning of the month (for example, sort all April
birthdays/anniversaries on April 1), but I have not been able to figure out a
filter. My problem is, of course, that If I use the Between... and...
function typing in Between #4/1/1900# and #4/31/2006#, I get EvERY date
between then and now, not just April. How do I work around this??

Thanks everyone.

 

[Tom Ellison]

Dear Fullerton:

Since you are asking for a calendar month, how about filtering where
Month(YourDate) = 4?

Replace "YourDate" with the actual name of the column.

Tom Ellison

 

[Duane Hookom]

Create a new column/field in your query with an expression like:
BirthMonth: Month([BirthDateField])
and set the criteria to something like:
[Enter Month Number]

Or reference a control on a form in the criteria like:
Forms!frmRptParams!txtMthNum

 

[Guest]

Thanks Tom. Actually, I figured out a Criteria that helped out just as well.
I typed in Like 4/**/**** and that got the desired results. I'll keep yours
in mind too for future queries.

 

[Duane Hookom]

You are relying on Access correctly using your regional date settings and
converting date values to text. I would never do this. Tom's solution is
much more effective.

If you provide the SQL view of your current query, someone would provide a
more robust alternative.