Set end of year date

[captnk]

Currently i have a query that uses a date as part of the query eg 31/7/2003.
However I want that date to change to 2004,after 31/7/2003 has expired
Is there anyway to have the computer update according to its own time

the query ruuns like
IIf <than 31/7/2003 then do this.
So it is not a standalone date
Any ideas welcome

 

[ColinEssex]

I did something vaguely similar.

I had a hidden field on the switchboard form that has a date in it. When the switchboard form opens, it checks if the date has passed. If it has then update the hidded field to the new date.

You can then reference the hidden field from the query criteria if the switchboard form is minimised but not if its closed of course.

Col