Plus/minus days

Topic Labels: Formulas
492 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, I’m trying to come up with a formula ({FIELD} + 30 days - today’s date.) This seems to be an easy one but I’m missing something. Any ideas?

1 Reply 1

The exact answer is going to depend on what exactly {Field} is. You can probably figure out the answer yourself from the following:

DATEADD(TODAY(), -30, 'days')
^ That gets you “30 days ago”. If {Field} is supposed to increase the number “30”, then adjust the formula to -(30 + {Field})