Setting a new end date in the timeline view
Click on ••• to the left of the blue New button, then select Layout and enable Separate start and end dates. Click on End date and select the formula property you created.
End Date
if(start(prop("Dates")) == end(prop("Dates")), if(now() > prop("Dates"), now(), fromTimestamp(toNumber(""))), end(prop("Dates")))
Explanation
if(start(prop("Dates")) == end(prop("Dates")),
If the start and end dates of Dates are the same (
end
will return the same date as start
if there is only one date set), do the following.if(now() > prop("Dates"), now(), fromTimestamp(toNumber(""))),
If the current date is greater than the date in Dates, display the current date. Otherwise, display nothing.
, end(prop("Dates")))
If the start and end dates of Dates are not the same, display the end date.