How to calculate out "Year" in an Event Form
To calculate out year in the Event Form, you need to use a date field set up within the form, e.g. a data override field
Next add in a Text calculation to return the Date field (e.g. Date of first symptoms) and set the advanced properties to hidden
Then add in a "calculation" that references the text calculation field. Set it to be hidden
Add in a calculation field:
floor(((First symptoms +63158400000)/31557600000)+1968)
-set it to hidden and not visible in tables
-set the format to 0 with no decimal places.
You could use this in reports, but it you wanted to be able to see injuries over time on a body diagram you need this to appear as an option... Hence, you add in an "option calculation"
Add in an "Option Calculation" field and paste in the options below
Add in the Year field to the calculation
Add in these Options to cover the time period from 2000 until 2012
This will calculate out year to appear in the athlete history and reports. It can also be used to group data in a body diagram (as shown here).
You will need to run a resave of the data to ensure all of the historical data is recalculated.
Make sure all users have synched their injury data and that you do it at a time whem most users will not be using the system.