How can I determine a duration between a starting date and ending date or today's date only calculating after 3yrs from the starting date?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Photo of Casameira Reyes

Casameira Reyes

  • 470 Points 250 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,856 Points 50k badge 2x thumb
Not tested, but try this as a Formula Duration field.

var date StartPlusThree = AdjustYear([Starting Date],3);

var date EndDate = if(not isnull(Ending Date]), [Ending Date]), Today());

Max(Days(0), $EndDate - $StartPlusThree)