Date minus 1 year

[asp_learner]

Can anyone tell me how to manipulate dates
so that if November, 1 2001 is entered I can make a txtfield November, 1 2000.

I am making a form that will summarize data for a period of time but I also need to be able to automatically query data for the same period the previous year.

One thought I had was to have four fields,
one txtbegDate, one txtendDate, one txtLybegDate, one txtLYendDate but if I could automatically set the LYbegDate from txtbegDate that would be great.

Thanks,
Eva


Thanks,
Eva

 

[Jack Cowley]

The only date that I would store would be the current date. You can use the DateAdd function to help fill in your form if your form is being used as criteria for your query.

 

[asp_learner]

Thank you so much, it worked.

Eva