Dynamic Fiscal Year Switch for Current & Previous fiscal year

[chinma]

Team,

We have date table with date range starting from 1st Oct-2022 to 30th-Sep-2030. Our fiscal year starts from October 1st.

Please guide me on creating Fiscal year switch (for current & previous fiscal year only) but dynamically it can change based on the year goes by.

Thank you

[chinma · Accepted solution]

Thanks @Ahmedx . It worked for me.

[Ahmedx]

pls try this

[chinma · Accepted solution]

Thanks @Ahmedx . It worked for me.

[Ahmedx · Accepted solution]

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly