SUBSTRACT DATE ISSUES

[JMSNYC]

Hi.

I need to subtract an integer number of months from an existing date (e.g., -6 month from April, 1 2019).

Issue is: I have a blank cell using DATEADD(Date(2019,04,01),-6,MONTH), because date should be November, 1, 2018. It seems that date subtraction works if year does not change.

Am I missing something ?

Thanks for your help.

[Ashish_Mathur · Accepted solution]

Hi,

Does this work?

=EDATE(Date(2019,04,01),-6)

[Ashish_Mathur · Accepted solution]

Hi,

Does this work?

=EDATE(Date(2019,04,01),-6)

[JMSNYC · Accepted solution]

AWESOME !!! Thank you so Much.

[Ashish_Mathur]

You are welcome.

[HotChilli]

Usually this is due to the end result of the dateadd operation not existing as a date in the model so that's my educated guess.

From documentation : The result table includes only dates that exist in the dates column