Query Criterion of same date every year

User avatar
silverback
5StarLounger
Posts: 780
Joined: 29 Jan 2010, 13:30

Query Criterion of same date every year

Post by silverback »

Our user wants a query to extract salary review information. The date criterion for the extraction has to be 1st April every year.
I've experimented with a calculated column, using an expression of "1/4" & Year(Now()) which does the trick, but this won't work on the criterion line of the query in design view.

What is the criterion formula to be 1st April every year (without asking the user to input the date via a parameterised query), please?

Thanks
Silverback

User avatar
HansV
Administrator
Posts: 78705
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Query Criterion of same date every year

Post by HansV »

Use

DateSerial(Year(Date()),4,1)
Best wishes,
Hans

User avatar
silverback
5StarLounger
Posts: 780
Joined: 29 Jan 2010, 13:30

Re: Query Criterion of same date every year

Post by silverback »

Many thanks
Silverback