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

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'

)

DATEADD(

   {Shipping Date},

   0 - VALUE({Days to maturity}),

   'day'

)

It produces an error.

Ok, remove the VALUE() portion:

Perfect! Thank you very much.