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.
Use day of the year to calculate countdown
This topic has been closed for replies.
You have to use DATETIME_DIFF([date1], [date2], 'units').
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.