Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zim327
Yak Posting Veteran
62 Posts |
 Posted - 2009-04-21 : 13:55:52
|
| Good afternoon, (my apologies if this is the wrong forum to post this in...) I'm creating a database and web front end to track when requirements are due. Now the current issue is recurrence. i.e. a requirement can be due anywhere from once to every 15th of the month, weekly, monthly, every 45 days, every 2 months etc. etc.sometimes it can be due how ever many business days or calendar days too. Basically, are there pre existing date functions that create recurring-date functionality like that in Microsoft Outlook?p.s. dates only, time isn't necessarythanks,Best regards, Zim(Eternal Yak God Emperor from the Future) |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-04-21 : 14:25:31
|
| I didn't understand what exactly you want. May be some sample data and outtput will help. Also, Look for dateadd function. I am guessing thats what you are looking for |
 |
|
|
Zim327
Yak Posting Veteran
62 Posts |
Posted - 2009-04-21 : 14:30:06
|
| sorry, here's the gist of it:Basically, are there pre existing date functions that create recurring-date functionality like that in Microsoft Outlook?Best regards, Zim(Eternal Yak God Emperor from the Future) |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-04-21 : 14:36:38
|
| this ?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58479 |
|
|
|
|
|
|
|
|
make copies of a record with different due dates