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 ----...
Forum Discussion
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
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.comMark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Only if both fields are not blank
------------------------------
Mike Sanders
------------------------------- IF(not IsNull([Date 1]) and not IsNull([Date 2]),
Max([Date 1], [Date 2]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Great, thanks Mark!
------------------------------
Mike Sanders
------------------------------
