Forum Discussion
EpicTriffid
Helper IV
6 years agoDealing 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...
EpicTriffid
Helper IV
6 years agoHi 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 😕