I'm trying to extract the FY from a date. In our world the Fiscal years run from July to June & hence 1/07/19 would be FY20
I could convert the date to a Time Period & have a separate module that maps the Time Period to FY but I thought that might be overkill?
Go to Solution.
View solution in original post
You should have a SYSTEM (as part of DISCO) module for time settings, where you can convert dates/periods into FY and can be referenced elsewhere in the model.
Calculate once and reference many times. You can directly convert the date into Year time period.
Arun's right. Time setting module is a must have in every model (almost).
You can download the time filters app from the app hub to have an example:
Thanks Nathan & Arun. I have a Time Filter module but I was asking more specifically as to how to convert a date/period & return the FY?
I was incorrectly thinking the PERIOD function would only return the month of the date, rather than the Time Period selected as the list value!
App downloaded & checking it out
Also check out the INPERIOD() function
In a module dimensioned by year, this can identify in which year the date falls
Hope that helps
Actually this works on any module by time