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
e.g.
Add in these Options to cover the time period from 2000 until 2012
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
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.
You could also use a Text Calculation to get the 'Date Field' into a text string.
Date to Text = date(Date Field,"dd-MM-yyyy")
And then another Text Calculation to split the year out of this string.
split(Date to Text,"-",2)