Question

Hello,
I have a formula that pulls out the max date(the last date) from two columns, however the formula does not work unless both columns have an entry. I still need the formula to work if one of the columns has a date. What can I add to make this work?
I appreciate any help you can provide.

Current formula:

fromTimestamp(max(timestamp(prop("Column A")), timestamp(prop("Column B"))))

Answer 1

You need to extend the arguments to compare everything.

I am using Date 1 & 2 for the Notion columns, so modify them as needed.

if(empty(prop("Date 1")), prop("Date 2"), if(empty(prop("Date 2")), prop("Date 1"), fromTimestamp(max(timestamp(prop("Date 1")), timestamp(prop("Date 2"))))))

Here it is how the Notion formula works.

If Date 1 is empty, show Date 2, if Date 2 is empty, show Date 1, otherwise use the fromTimestamp formula.

Hope that helps.