AdjustMonth formula for calculating a date before a date field.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

"When we do a change form here at work, we need to send to client either 60 days or 6 months before the anticipated implantation of the proposal. Trying to setup a formula for the field [Date to be sent to client] that will be 6 months before the [anticipated implantation date] field or 60 days before the anticipated implantation date.  60 days or 6 months is based upon if a checkbox is checked or not.  This is what I had for my formula:

If( ([Major System Change?]=true),

 AdjustMonth([Anticipated Implantation Date]- (6)),

 ([Anticipated Implantation Date]- days(60)))

However I am getting an error stating I cannot use "-" in my formula.

Can anyone help me?

Thank you in advance,

Sandy

Photo of Sandralee

Sandralee

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
The


AdjustMonth function format may be your problem, try this:

AdjustMonth([Anticipated Implantation Date],-6)
Photo of Sandralee

Sandralee

  • 0 Points
Thank you!  That was it!