Date Calculations and the Age calculation

Date Calculations allow you to calculate out differences between date fields, and the duration from one date to another

Date Calculations allow you to calculate out differences between date fields, and the duration from one date to another

To Add in a Date Difference Field

Date Difference

Date Difference

Date Difference Calculation

This is used to calculate the length of time between dates that you have entered into your Event.

It is useful to calculate out length of injury, through to how long a vaccination is current for.

To calculate the difference between Dates:

1. Click on the Date Difference Calculation (rename the question, in this example we are using Days unable to train/play)

2. Select the From Date, the date that you want to start the calculation from (for this example we chose "Date of First Symptoms")

3. Select the To Date, the date that you want the calculation to end on(for this example we choose "Date Resolution")

4. Select the Units that you want the difference to be displayed in

-Day

-Month

-Year

5. When the date fields are added, the calculation occurs immediately (as shown in the image above).

Age calculations allow you to show the age of the athlete (in years, months or days) based on their date of birth in their account AND a specific date field that is added to the form.

To see the Athletes Age at the time an even is entered, click on "Age Calculation".

 

Name the field and add an visibility settings, the select the Age At date (in the form) that you want the age to calculate from (you MUST have a date field in the form to run this calculation)

Name the field and add an visibility settings, the select the Age At date (in the form) that you want the age to calculate from (you MUST have a date field in the form to run this calculation)

Select the Age At date, and choose a date field entered into the form. The date of entry is a date field that has been entered into the form, specially to calculate the age calculation.

Then select the Units that you want the Age to show as: days, months or years.

If you do not have a date field in your form, add in a date field, rename it to Date of Entry (or a similar name) and the set the FORM'S ADVANCED PROPERTIES as having a date override.

If you do not have a date field in your form, add in a date field, rename it to Date of Entry (or a similar name) and the set the FORM'S ADVANCED PROPERTIES as having a date override.

Set the Form's advanced properties to having a date override so that the date of entry will appear instead of the Date field in the form... see the image below for an example. To find out more about the Date Override Feature see the Form Advanced Properties Lesson in the Help Manual.

The age calculates automatically in the data entry form based on the selected date field.

The age calculates automatically in the data entry form based on the selected date field.

0 Comments

Add your comment

E-Mail me when someone replies to this comment