Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a list box properties which is looking for a dimension calendar year, from 2011 to 2020
I want to use field as a expression and use a formula that only shows 3 years prior the current. Does anyone knows which formula can I use?
Thanks
Joanna
Hi Joanna,
=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)
Or
=Aggr(Only({<Year={">=$(=Year(Today())-3)<=$(=Year(Today()))"} >}Year),Year)
Hi Joanna,
=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)
Or
=Aggr(Only({<Year={">=$(=Year(Today())-3)<=$(=Year(Today()))"} >}Year),Year)
Thanks so much Tamil appreciate your help 😃
Anytime. Kindly close the thread, if your query was answered. Thank you and have a nice day.