How to get Current Fiscal Year from Time, as a number, when Current Period is not set in the model
Hi, can I get help in how to derive Current Fiscal Year, set in Time, as a number when Current Period is not set in the model?
I see how to get year if Current Period is set with year(currentperiodstart()), but what to do when it's not used? We currently have a line item in a Time Filter module that requires the year to be input. I'd like to automate this based on the FY in Time so we dont forget to update yearly....is this possible-simply? It's not a big deal to input, but...
thanks in advance