I have a form wherby the user chooses a frequency of Monthly, Quarterly, Half-Yearly or annually.
They then choose an initiation date. and a life-span
there is another form wherby the user can see their 'risks' that are due for review. for example if the initiation date for risk number 001 is 01/01/03 and the frequency is quarterly and the lifespan is 2 years, the review dates would be 01/04/03, 01/07/03, 01/10/03, 1/1/04, 1/4/04, 1/7/04 and 1/10/04.
so say todays date is 30/03/03 then if the user chooses to view risks due soon (between todays date and 7 days for example) the form would open risk 001 as there is a risk review due on 01/04/03.
How would I go about doing this?
many thanks
They then choose an initiation date. and a life-span
there is another form wherby the user can see their 'risks' that are due for review. for example if the initiation date for risk number 001 is 01/01/03 and the frequency is quarterly and the lifespan is 2 years, the review dates would be 01/04/03, 01/07/03, 01/10/03, 1/1/04, 1/4/04, 1/7/04 and 1/10/04.
so say todays date is 30/03/03 then if the user chooses to view risks due soon (between todays date and 7 days for example) the form would open risk 001 as there is a risk review due on 01/04/03.
How would I go about doing this?
many thanks
