Current Date as End Date

Current Date as End Date

💡
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.
 
By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!By Ben  •  Latest  •  Was this helpful? Please consider buying me a coffee. Cheers!
By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!