ORD - how to create a column to produce the difference in dates resulting in years as a decimal.
Currently if a calculated column is created with the formula DateX minus DateY, the difference will be displayed in number of days. See eg. below for Time In Position, this will result in the number of days displayed in the calculated column.
Create calculated column with the difference in dates formula to get the number of days difference between two dates. Make sure that there is no function parameter set as cicled below.
Create a second calculated column with a number data type. Select the previous calculated column (in e.g. above this would be Time in Position) and divide by 365 to give the result in years. Also, edit the number format to reveal more decimal places if required (more accurate).
KBA , LOD-SF-ANA-ORD , Online Report Designer , How To