Checking Date Fields

Question

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

markshnier__you · Answer

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 · Answer

Only if both fields are not blank------------------------------Mike Sanders------------------------------

markshnier__you · Answer

IF(not IsNull([Date 1]) and not IsNull([Date 2]), Max([Date 1], [Date 2]))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

mikesanders · Answer

Great, thanks Mark!------------------------------Mike Sanders------------------------------

mikesanders · Answer

One more question.&nbsp; Can you override the formula date at all?------------------------------Mike Sanders------------------------------

Forum Discussion

Checking Date Fields