dateBetween(end(prop("Date")), start(prop("Date")), "days")
empty(prop("Date")) ? "No Date" : ((formatDate(start(prop("Date")), "L") == formatDate(end(prop("Date")), "L")) ? "No/Same End Date" : (format(dateBetween(end(prop("Date")), start(prop("Date")), "days")) + " days"))
empty(prop("Date")) ? "No Date"
If Date
is empty, display No Date
: ((formatDate(start(prop("Date")), "L") == formatDate(end(prop("Date")), "L")) ? "No/Same End Date"
Otherwise if the start Date
formatted as a localised DD/MM/YYY
is the same as the end Date
formatted as a localised DD/MM/YYY
, display No/Same End Date
(a date with no end date selected will output the start date as the end date).
: (format(dateBetween(end(prop("Date")), start(prop("Date")), "days")) + " days")
Otherwise display the number of days between and add days
after.
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>