asp_learner
Registered User.
- Local time
- Today, 17:28
- Joined
- Jun 7, 2001
- Messages
- 46
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
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