Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Need an calculation command/essbase function which calculates the number of days for a month — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need an calculation command/essbase function which calculates the number of days for a month

Accepted answer
27
Views
4
Comments
edited Oct 16, 2020 10:25AM in Planning 4 comments

Summary

Need an calculation command/essbase function which calculates the number of days for a month

Content

Hi 

This is with regards to rolling budget in Planning. 

We are using rolling periods which get created as substitution variables when creating rules for rolling budget. 

And i need a function which calculates the number of days based on the month we are in. 

For example if &RollPer1 is "Apr" then it should be 30. 

And if &RollPer1 is "May" then it should be 31.

 

I have seen this function which serves the solution for my issue. That is @CalcMgrDaysBetween. But here we need to give fromdate and to date. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!