search for date of this year

[fadetoblack]

In my database I has 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

 

[mhartman]

Hello
The below function will return the Year portion of a date:
'
=Year(Now())
Make sure your table field has the Datatype set to Date / Time.
'
Regards
Mark