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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calendar list with multiple dates?

Status
Not open for further replies.
Mar 5, 2021
3
0
0
US
I need to make a Calendar list that has multiple start/stop dates (no need times) that skips weekends...

The thing is, this is for scheduling construction crews. Sometimes they will have a week on a job site at a time sometimes a day here and a day there. I have no idea how many date ranges will be needed so i can't just make date ranges for all options...

My first thought was with database design, having a one to many table design where the main info is on one table and the dates are all on another table with a one to many relationship based on job number...

Any thoughts to get me going in the right direction would be helpful!

btw, we're using sharepoint online as part of Office 365 for business...

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top