troubleshooting Question

Calculate week number offset against a date range and including the year

Avatar of joelem18
joelem18 asked on
Lotus IBM
6 Comments1 Solution387 ViewsLast Modified:
I've had a look at this https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_22053527.html which helped me understand on how to do it for one date. My problem is that I have two dates on my documents, Start Date and End Date. I want to know how I can do the same thing but instead for all the dates in between Start Date and End Date. I require this since I want to create a view categorized in this format 'Year - Week Number'

To make myself clear, let's say I have a document with Start Date 02/10/2007 and End Date 10/10/2007. I would want this document to appear in the view under two categories '2007 - Week 40' and '2007 - Week 41'

Thanks in advance
ASKER CERTIFIED SOLUTION
qwaletee

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros