Extract FY from Date

Hi Team,

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?

Many thanks

Mark

Accepted answers

ArunManickam

@MarkTurkenburg

Thanks

Arun

All comments

ArunManickam

Hello Mark,

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.

Thanks

Arun

nathan_rudman

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:

https://community.anaplan.com/t5/Learning/Time-Filters/ba-p/28086

MarkTurkenburg_*8288

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?

Cheers

Mark

ArunManickam

@MarkTurkenburg

Thanks

Arun

MarkTurkenburg_*8288

Thanks @ArunManickam

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!

Mark

nathan_rudman

MONTH() returns the month
you should take a look at my time filters app you might find some inspirations 🙂

MarkTurkenburg_*8288

Thanks @nathan_rudman

App downloaded & checking it out

Mark

DavidSmith

@MarkTurkenburg

Also check out the INPERIOD() function

In a module dimensioned by year, this can identify in which year the date falls

Hope that helps

David

DavidSmith

Actually this works on any module by time

David

MarkTurkenburg_*8288

Nice one @DavidSmith

Thanks

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…