Time filter for current FY

fredrickstraube

Hi,

I have an issue related to time filters. I have a module dedicated to time filter which I use for my other modules to show the relevant years/months. 

My fiscal year is from jun-may, and I want a filter showing only the current FY, that is from jun 2021-may 2022.

I hence want to have booleans ticked for those months but not for any other. It seems quite simple, but I cannot find a neat way to do it - anyone have any suggestions?

Thanks a lot in advance!

rob_marshall

@fredrickstraube 

 

You can use the function CurrentPeriod() if you are setting the current month in Time Settings.

 

 

Then, create a SYS Time Module with the following line items:

FY Year (formatted as Period Year):  

 

 

The other line item needed is Current Year formatted as a boolean

 

Hope this helps,

 

Rob

bhubeshrana

Your time setting should be like this:

 

and time Setting module should have following line items:

and result will be :

 

ChrisAHeathcote

Follow the advice from @rob_marshall  but also make sure to update the 'Fiscal Year Start Month' to June. 

fredrickstraube

That worked perfectly, thanks a lot!