Formula help please [NewDateField] look at the dates in [date1], [date2], [date3] and display the earliest date. If there is not date in any, display today ().

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

Please help me figure out how to generate a date field by looking in 3 other date fields and displaying the earliest date, but if there are no dates, use today's date

Photo of jabrey

jabrey

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
Min([Date1], [Date2], [Date3], Today())
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Or alternatively

var date MinDate = Min([Date1], [Date2], [Date3]);

IF(not IsNull($MinDate), $MinDate, Today())

This version would deal with all of the dates being in the future.