05-02-2017 10:08 AM
The question is from the Prep Guide.
I was anticipating the answer 05feb97.However, the value is 13515 i.e., January1,1997. Why is that so?
However, the same functin used on semiyear yield the value as expected.
targetMonth=intnx('semiyear','01jan2001'd,1) and the answer is 01July2001.
05-02-2017 10:16 AM
It just did what you asked it to do. If you want it to find the same point in the interval you need to tell it that.
05-02-2017 10:21 AM
INTNX() has 4 parameters, you've specified 3.
The fourth parameter tells it how to align the dates: beginning, same, end, middle.
The default is the beginning, which is being used.
Need further help from the community? Please ask a new question.