Help

How to subtract a number from a date

Topic Labels: Formulas
Solved
Jump to Solution
2176 10
cancel
Showing results for 
Search instead for 
Did you mean: 
idan_bernard
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
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter
DATEADD({Date Field}, -1, 'week')

See Solution in Thread

10 Replies 10
Jeremy_Oglesby
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 !
Phil

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:

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

It produces an error.

Ok, remove the VALUE() portion:

image

image

Perfect! Thank you very much.