Dates used in a Table can now be used in a Table Date Calculations to return a Date field instead of a Text field

Previously a table date calculation only returned a text output, not a date output. Now date calculations can be used for date fields used in a table.

A new table calculation that outputs table calculations using date fields is available

A new table calculation that outputs table calculations using date fields is available

Once a Table Date Calculation is entered into the form select the Aggregate: first, last, or last entered value.

Once a Table Date Calculation is entered into the form select the Aggregate: first, last, or last entered value.

Write in "raw value" before the name of the date field to return the date for the specified table column

Write in "raw value" before the name of the date field to return the date for the specified table column

Once the calculation is written, ensure the correct date format is set on the Advanced Properties for the calculation/s

Once the calculation is written, ensure the correct date format is set on the Advanced Properties for the calculation/s

N.B. If no format is selected it will default to dd-MM-yyyy

On the system, the output of the table calculations is a date field.

On the system, the output of the table calculations is a date field.

This will appear as a date field in the athlete history/reports page

N.B. Table Date Calculation outputs can be used in other date calculations, like date difference calculations

N.B. Table Date Calculation outputs can be used in other date calculations, like date difference calculations

For example, calculating the difference between the first value and last value outputs

For example, calculating the difference between the first value and last value outputs

Or, calculating the difference between the Event date (e.g. on On Date that is selected at the top of the event form) and the last entered table calculation

Or, calculating the difference between the Event date (e.g. on On Date that is selected at the top of the event form) and the last entered table calculation

On the system, once the table date calculations run, the other date difference calculations run as expected.

On the system, once the table date calculations run, the other date difference calculations run as expected.

0 Comments

Add your comment

E-Mail me when someone replies to this comment