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

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

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 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.

1 Comments

Peter kyffin

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)

Add your comment

E-Mail me when someone replies to this comment