Filtering Dates in Query

[Smurfit-Stone]

Hello Board, I'm trying to create a filter in a query for a date field. The field is formatted as a short date, i.e. 00/00/0000. I'd like to query on the month only. Example...I'd like to filter all dates in February. I've tried the Month(2) function and even the MonthName(2[,Feb]) and nothing seems to work. If I query ---Like "02" I get everythin in 2002, so why can't I get everything in a particular month? Please help. I need to query on Birthdays for a whole month no matter what year they were born in. Thanks in advance Board.

Saved By Grace

 

[Andrew Fergus]

Hi, this can defintely be done. Add the date to your query twice, on the first date change the field "date" to this :

Expr1: Month([date])

and in the criteria section under this modified field enter the value 2.

Save and run. Add additional fields as required and be sure to use your actual variable names.

The SQL for just the dates looks like this (if you want it) :

SELECT Month([date]) AS Expr1, dates_table.date
FROM dates_table
WHERE (((Month([date]))=2));

HTH, Andrew

 

[Smurfit-Stone]

Andrew, you terrific....it works like a charm. Thanks a million. I've been trying all kinds of stuff all morning. Thanks Again


Terylgirl