Entries
Days Between (Number)
dateBetween(end(prop("Date")), start(prop("Date")), "days")
Days Between (String)
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.
