Filter all dates within current month

[wanderanwills]

Hello I am new to the forum, and self learning Access.


I am probably quite wrong but I am trying to apply a filter that returns all dates within the current month

The bulk of the filter is from Microsoft Access examples.

Private Sub MonthB_Click()
DoCmd.ApplyFilter , "DueDate Year([DueDate]) = Year(Now()) And Month([DueDate]) = Month(Now())"
End Sub

It is not working??
Any help would be greatly appreciated.


Regards
Stephen

[Bob Fitz]

Have checked that the code is actually being fired

[orange]

I don't know your tables and fields, but it looks like there is an extra space in this

DueDate Year

As with most posts, it would be helpful if we understood your database and what you are trying to accomplish.

It is not working?? is not very helpful. As Bob asked --Do you know for sure that the code you highlighted is actually being executed? Do you get error message(s)?

Also, Now includes time. I think you should change and use Date() instead of Now().

[wanderanwills]

Hi Everyone,

Solved.
"DueDate Year([DueDate]) = Year(Now()) And Month([DueDate]) = Month(Now())"
Removed the 'DueDate' at the front.

Thankyou for replying.

Regards
Stephen