Basically I need a formula to check if the date calculated is past a certain date. If so it defaults to that certain date. If((Today() + Weeks(12))>3-31-2017, 3-31-2017)

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I know the formula is wrong...I knew it before quickbase told me implicitly that it was...but I don't know enough to create the values in the proper format that quickbase will accept.

As reference here is the formula I created.

If((Today() + Weeks(12))>3-31-2017, 3-31-2017)
Photo of Tim

Tim

  • 0 Points

Posted 2 years ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
Try this:

Min(
  Today() + Weeks(12),
  Date(2017, 3, 31)
)
Photo of Tim

Tim

  • 0 Points
Perfect! Thanks you so much!