working with intnx function

alepage — Wed, 08 Jan 2025 22:24:58 GMT

Hello,

I am using the intnx function to estimate new dates based on the interval.

In term of interval, I am trying to find the documentation on it. Maybe I am not lucky.

it could be day, week, month, quarter and year.

What's the name of a four months interval.?

How do we define a custom interval ?

Please provide an example.

Also, in a old calendar, I have something refering to prv begining of the year and end of the year

which gives 28DEC2013 02JAN2015

Does someones know what it is

28DEC2013 is a Saturday and 02JAN2015 is a Friday.

So some week definition that start a Saturday and finish on Friday

Re: working with intnx function

PaigeMiller — Wed, 08 Jan 2025 22:39:45 GMT

Intervals you can use in INTNX, from the documentation

For custom intervals, scroll down in the documentation to "Multi-Unit Intervals"

Regarding weeks that go from Saturday to Friday, you can scroll down to "Shifted Intervals"