Question

There are two properties named Start and Finish. When I enter the same date in Finish and Start properties, the output is 0. If I select the Finish date as the day after the Start date, it appears as 1. However, I want the input to be 1 for both.

if(!empty(prop("Finish")), dateBetween(prop("Finish"), prop("Start"), "days"), toNumber(""))

This is how the formula starts. I would be glad if you help.

Answer 1

You can add a compare to always show 1 if the two Notion properties have the same date.

if(prop("Start") == prop("Finish"), 1, if(!empty(prop("Finish")), dateBetween(prop("Finish"), prop("Start"), "days"), toNumber("")))

Hope that helps.