Forum Discussion

MikeSanders's avatar
MikeSanders
Qrew Member
2 years ago

Checking Date Fields

Hi,

Plz bear with me, I'm pretty new.  How do i check 2 Date Fields and if they both have dates, add the most recent to a Formula - Date field?

------------------------------
Mike Sanders
------------------------------

7 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    Are you saying that you want a formula to calculate the highest most future date between two date fields. Or are you saying you only want to do this if both date fields are not blank.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.comMark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      2 years ago
      Only if both fields are not blank

      ------------------------------
      Mike Sanders
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        IF(not IsNull([Date 1]) and not IsNull([Date 2]),

        Max([Date 1], [Date 2]))

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------