Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I'm somewhat new to QS but have made a lot of headway. I have 3000+ lines of data, and each line has a date (DD/MM/YYY). I have set up filter buttons that can filter by calendar year while I have another filter button that can filter by month. Those expressions were pretty easy to write.
Now I'm trying to set up a new filter button that will filter by fiscal year. For instance, I want to have the option to filter Oct 2020 through Sep 2021 and name this 2020 - 2021.
I'm having trouble writing an expression to do this. Any recommendations?
YearName ( DateField, 0, 10)
can you try like :YearName ( DateField, 0, 4)
YearName ( DateField, 0, 10)
Thanks! This worked perfectly and was way easier than I expected the answer to be. I appreciate your help.