Hi,
We have a year data from Dec 2019 to Dec 2020 total 13 months data is available in DB. Need an expression rule based on the Date field we need to display the 13 months data in a Grid. Previous four months data should be in readonly and current four months data should be in editable.
Example (1) :
If selected the Date is 1st March 2020 then data should be displayed from Dec 2019 to Dec 2020.
Dec 2019 to March 2020 should be display in readOnly and April 2020 to Dec 2020 should be displayed in editable.
Example (2) :
If selected the Date is 1st May 2020 then data should be displayed from Dec 2019 to Dec 2020.
Jan 2020 to April 2020 should be display in readOnly and May 2020 to Dec 2020 should be displayed in editable.
Here, if user goes and edit on current month then previous four months should be readOnly and after current month, all months should be displayed in editable.
Your earliest response will be appreciated !
Discussion posts and replies are publicly visible
One question, i.e. in 2nd example,selected date being 1st May 2020 what happens to data for the month December 2019. It will be readonly or editable?
Hi Harsha,
For the Month December 2019 , it will be display in readonly.
Thanks..
Correction in Example (1) :
If selected the Date is 1st April 2020 then data should be displayed from Dec 2019 to Dec 2020.
From Dec 2019 to March 2020 should be display in readOnly and April 2020 to Dec 2020 should be displayed in editable.