How to find the longest date from 5 fields?

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

My project is composed of 5 different parts to complete.  I need know which one will take the longest time and use that one as my project end date.  Is there a way to do this?  I was thinking about doing WeekDaySub([project part# complete],today()) for each of the 5 parts and do a whole bunch of if statements to see which one is the longest then use that as the output.  But not exactly sure how that going to be comparing to each separate part.  Any input is appreciated.

Photo of Yang

Yang

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
Try this

Max([Date 1], [Date 2], etc [Date 5])
Photo of Yang

Yang

  • 0 Points
thank you so much.  I didn't know that the max function auto calculate the dates, thought I had to convert into days first.