Use day of the year to calculate countdown


Hi - I’m trying to do a simple table that calculates countdowns. For example, the first column would be a date (let’s say my anniversary) and the second column would calculate how many days the event is from the current date. I found the formula DDD but I can’t get it to work.


You have to use DATETIME_DIFF([date1], [date2], 'units').