9 Replies Latest reply on Oct 9, 2018 11:21 AM by Angie Chubb

# Calculating 12 months prior from a go live date

I am trying to calculate twelve months prior to a go live date. I have tried multiple different formulas and can't get it exactly.

Not every item will have a go live date so I have tried:

if not isnull([Re-Route GO Live Date]) then DATEDIFF('month',[Prior Month to Go live Date],[Prior Month to Go live Date])<=12 and DATEDIFF('month',[Prior Month to Go live Date],[Prior Month to Go live Date])>=1

END

Any help is much appreciated!

• ###### 1. Re: Calculating 12 months prior from a go live date

DATEADD('year', -1,[Date])  try this? since its 12 months i figured a year would work

• ###### 2. Re: Calculating 12 months prior from a go live date

It is close but I need all the months included between the go live date and twelve months after.

• ###### 3. Re: Calculating 12 months prior from a go live date

do you have all 12 months ? in the go live dates?

• ###### 4. Re: Calculating 12 months prior from a go live date

Could you use Kelly's formula but make it DATEADD('month', +12, [go-live date])??

• ###### 5. Re: Calculating 12 months prior from a go live date

I do not have all the dates in the go live date.

• ###### 6. Re: Calculating 12 months prior from a go live date

Hi Grace,

Adding null part to complete it

You will get NA for nulls

Thanks,

Ritesh

• ###### 7. Re: Calculating 12 months prior from a go live date

Hi- thanks for the help!

But i need to identify all 12 months prior to go live. Meaning I need it to state true if my go live was January 2018 for December 2017, November 2017, October 2017, etc..

• ###### 8. Re: Calculating 12 months prior from a go live date

Hi Grace,

Do you mean like this ?

In that case you need to duplicate the calculation & change -1 till -12

Not sure if this is your requirement

Thanks,

Ritesh

• ###### 9. Re: Calculating 12 months prior from a go live date

Sorry, I meant for this to be a -12!!! I clearly cannot type today.