Substract date in calcdate

Josetxo

Hello,

MyOldDate and MyNewDate are Date
NumberofDays is a Dateformula field
MyNewDate := MyOldDate - NumberOfDays

The problem is that I am not being able to make the NumberOfDays field negative, to substract it. I have tried to prepend '-' to it but it keeps giving a type error (NumberOfDays is a DateFormula field and the '-' is text).

MyNewDate := CALCDATE ('-' + NumberOfDays, MyOldDate); // but it keeps giving a type error

I need to maintain the NumberofDays field as a DateFormula field as well.
How can I make this work?
Many thanks in advance,
Josetxo

matttrax

Have you tried '-' + FORMAT(NumberOfDays)?

Josetxo

Tried and solved.
Thank you.