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

Ability to get "Actual" start/end date of next month in ARCS

edited Mar 10, 2026 6:45AM in Account Reconciliation

Is there any way to get "Actual" start/end date of next period in ARCS when running certain rules in current period. We do have EDATE function; however it returns value based on the current month start/end date.

For e.g. The calendar is setup for client

Feb - 2 Feb to 1 Mar

Mar - 2 Mar to 29 Mar

So in above case EDATE on end date for rule run in Feb will return April 1 as value. However, it's wrong and we want to retrieve actual end date value which is March 29.

Thanks in advance…!!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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