topic Session Variable forCurrent and Past two years in Data & Schema Discussions https://community.incorta.com/t5/data-schema-discussions/session-variable-forcurrent-and-past-two-years/m-p/6776#M588 <P>Hi,</P><P>Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how to achieve using session variable or any formula columns</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KHK_1-1762790489767.png" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2971iE1D862827194078A/image-size/medium?v=v2&amp;px=400" role="button" title="KHK_1-1762790489767.png" alt="KHK_1-1762790489767.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 10 Nov 2025 16:03:09 GMT KHK 2025-11-10T16:03:09Z Session Variable forCurrent and Past two years https://community.incorta.com/t5/data-schema-discussions/session-variable-forcurrent-and-past-two-years/m-p/6776#M588 <P>Hi,</P><P>Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how to achieve using session variable or any formula columns</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KHK_1-1762790489767.png" style="width: 400px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2971iE1D862827194078A/image-size/medium?v=v2&amp;px=400" role="button" title="KHK_1-1762790489767.png" alt="KHK_1-1762790489767.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 10 Nov 2025 16:03:09 GMT https://community.incorta.com/t5/data-schema-discussions/session-variable-forcurrent-and-past-two-years/m-p/6776#M588 KHK 2025-11-10T16:03:09Z