search for date of this year

fadetoblack

Registered User.
Local time
Today, 23:31
Joined
Aug 26, 2006
Messages
16
In my database I have a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year.

Is there a date function where I can have something like
Month([Date]), Year ([=Now])

thanks
 
You need to use two separate conditions, one to compare on months and one to compare against the current year.

RV
 

Users who are viewing this thread

Back
Top Bottom