How to subtract a number from a date

Topic Labels: Formulas
Jump to Solution
3022 10
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

hey, whats the formula to subtract a week from a field with a date?

thanks alot!

1 Solution

Accepted Solutions
14 - Jupiter
14 - Jupiter
DATEADD({Date Field}, -1, 'week')

See Solution in Thread

10 Replies 10
14 - Jupiter
14 - Jupiter
DATEADD({Date Field}, -1, 'week')

I’m trying to do something similar, but got an error…

Here’s the formula :
DATEADD({Shipping Date}, -{Days to maturity}, ‘day’)

Shipping Date is the date of shipping the crop order.
The Days to maturity is a lookup field from another table describing my crops.
I want to know my planting date by subtracting the number of days to maturity from the order date.

The formula return an error. Please can you tell me what I am doing wrong ?
Thanks alot !

Just curious… if you remove the “-“ that’s before your second field name, does that at least solve the problem of the formula throwing an error?

Nope, no error, just give me the same date as in Shipping date…

Is {Days to Maturity} a number field? Formula field?

It’s a lookup field from another table. In it’s table it is an integer.

Try this:

   {Shipping Date},
   0 - VALUE({Days to maturity}),

It produces an error.

Ok, remove the VALUE() portion: