year date

[kingsgambit]

I am trying to get a query to show records from the 1/1/02 to 31/12/02, so the user can see what holidays they have had ,but have the year set to the current year. I used

Field Year: Format([Start date],"yyyy")
Criteria Format([now()],"yyyy")

The query asks for a input for now(), what is the right criteria

 

[Jon K]

now() is a built-in function. Remove the square brackets from it.