Forum Discussion
Solved
Academic Year
I work in a school and I have daily attendance data (including a date column) in a table going back to 2017. I want to add a column that shows the academic year for each record. E.g. a date betw...
Ok, worked out a solution but possibly not the neatest. I created a table with every possible date with the academic table in another column the created a relationship to the date column.
Ok, worked out a solution but possibly not the neatest. I created a table with every possible date with the academic table in another column the created a relationship to the date column.