Countdown to target date instead of using a calendar date

[danw]

I want to create a template for an event (or editorial) calendar where Day Zero is the date of the event/launch etc, and all tasks are relative to that target date. i.e. 10 days prior to launch or Day 10 or etc. How can I do this?

[Databaser]

Hi @danw and welcome to the community!

Check out the DATETIME_DIFF() function for this.