Forum Discussion
EpicTriffid
Helper IV
Helper IVDealing with Academic Years
Hi all, So I'm currently trying to create a KPI report and I'm encountering some difficulty with academic year (e.g. 2017/18, 2018/19). This is how we report all our data as the academic year st...
sturlaws
Resident Rockstar
Resident RockstarHi EpicTriffid ,
do you have a separate date table? With a separate date table, with a relationship on "normal" date, you can have second column in the date table with [Academic year]. I think this will give you the behaviour you are looking for
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
EpicTriffidHelper IV
Helper IVHi sturlaws
Thanks for the response. I tried what you suggested but no luck. With a date table, and a relationship between the normally formatted dates in both, it still doesn't work. Here it is with the formatted date:
And with the "Academic Year" (called Actual Year here):
Im a little lost as to why it's not working 😕