Current Date as End Date

<aside> 💡 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.

</aside>

End Date

if(start(prop("Dates")) == end(prop("Dates")), if(now() > prop("Dates"), now(), fromTimestamp(toNumber(""))), end(prop("Dates")))

Explanation

<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>