How to subtract a number from a date

[idan_bernard]

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

thanks alot!

[Jeremy_Oglesby · Accepted solution]

DATEADD({Date Field}, -1, 'week')

[Philippe_Jedar]

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 !
Phil

[Jeremy_Oglesby]

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?

[Philippe_Jedar]

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

[Jeremy_Oglesby]

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

[Philippe_Jedar]

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

[Jeremy_Oglesby]

Try this:

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

[Philippe_Jedar]

Jeremy_Oglesby:

DATEADD( {Shipping Date}, 0 - VALUE({Days to maturity}), ‘day’ )

It produces an error.

[Jeremy_Oglesby]

Ok, remove the VALUE() portion: