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
Query Criterion of same date every year
-
- 5StarLounger
- Posts: 780
- Joined: 29 Jan 2010, 13:30
-
- Administrator
- Posts: 78705
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 5StarLounger
- Posts: 780
- Joined: 29 Jan 2010, 13:30
Re: Query Criterion of same date every year
Many thanks
Silverback
Silverback