auto calculate date 1

[thefroggy]

I’m using access 2000, here is the prob I’ve got.

I’m trying to create a field where a date will be automatically entered. My colleagues need to review the data every five years to check if not out dated.

I’m using a =date() expression to set the date, and I’d like to create a field where 5 years is added to today’s date. How can I do that?

Thanks,

Steph.

 

[Mute101]

Hi Steph,

You can use the DateAdd function to do what you need. eg.

DateAdd("yyyy", 5, date())

Hope that helps

Sim


----------------------------------------
I was once asked if I was ignorant or just apathetic. I said, "I don't know, and I don't care."
----------------------------------------

 

[thefroggy]

Thanks Sim,

Works exactly the way I wanted. Gave you a start for the help.

thanks again,

Steph.