How to get new year date

H

Huayang

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks
 
J

John W. Vinson

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks
Click to expand...

Please explain. It is not clear what you are asking. To get the year number
from a Date/Time field use

Year([datefield])

I have NO idea what you mean by "set var value to 0".

John W. Vinson [MVP]
 
H

Huayang

I mean that when from this year 2007 into year 2008, my Access 2000 program
can automatically set integer Var value to 0.

John W. Vinson said:
How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks
Click to expand...

Please explain. It is not clear what you are asking. To get the year number
from a Date/Time field use

Year([datefield])

I have NO idea what you mean by "set var value to 0".

John W. Vinson [MVP]
Click to expand...
 
J

John W. Vinson

I mean that when from this year 2007 into year 2008, my Access 2000 program
can automatically set integer Var value to 0.
Click to expand...

Do you want this to happen at midnight on January 1?

What if the database is not open?

Do you want the var to be set when you open the database for the first time in
2008?

Where and how is this "var" used?

Huayang, *you* can see your database; you understand what it is intended to
do. We do not. Please explain the context - what you are trying to ACCOMPLISH.

John W. Vinson [MVP]
 
Top