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

How to change the Year in a form when the previous month column is the first period of the year?

Received Response

Hi all,

In our application we created some Forms in which we have 2 columns, in one column you see the period selected in the pov and in the second the Relative(&Period,-1)

when you select the first period of the fiscal year (in our case September) you correctly see in the second column August but for the same year in both the columns.

There is a way to have in the second column the year change when current month is September -> Previous month is August but also previous year.


Howdy, Stranger!

Log In

To view full details, sign in.


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