Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to repeat current record by a week or month
- Thread starter macnali
- Start date
MichaelRed
Programmer
not a whole lot to go on here, but the basic approach would be to set up an input to select the interval (daily, weekly, monthly) and use dateadd(interval, 1, startdate in a loop. Look up the arguments for the dateadd function, interval is day, week, month, etc (not the correct codes, but the "information", startdate is - obviously - when to start the process.
Do this in the loop which runs for the number of intervals desired. You will probably want to also limit the actual schedualing in some manner, so you can keep from going out to infinity.
Another approach would be similar, but include a "flag" in the schedual, which is to "notify" the system to 'reschedual' thiitem when it's date occurs. This would perpetuate the item until some one removed the flag.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
Do this in the loop which runs for the number of intervals desired. You will probably want to also limit the actual schedualing in some manner, so you can keep from going out to infinity.
Another approach would be similar, but include a "flag" in the schedual, which is to "notify" the system to 'reschedual' thiitem when it's date occurs. This would perpetuate the item until some one removed the flag.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads