Days Executed Over Timeframe

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Have a challenging reporting requirement. Say I have a Task record with a start date, # days to complete and a calculated finish date based on the first two data points. Is there a way to create a report that describes the numbers of days executed for that task within a given timeframe?

Example, the Task starts July 27, takes 10 business days and endw August 10th. Can I create a report that says it tooks 3 business days in July and 7 business days in August?

Photo of Ben

Ben

  • 40 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
..,  and what would the result need to be if the time frame took 8 months?
Photo of Ben

Ben

  • 40 Points
If the task took 8 months? Then the full number of days within the queried time frame. So if it still started July 27th 3 days in July, 31 in August, etc.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
I can write a formula but I think that it would take me 30 minutes to mess around with it and get it working.  Contact me via the information in my profile if no one else posts an an answer and you really need this done.