Page 1 of 1

Calculating Age from DOB

Posted: Mon Nov 18, 2013 9:25 pm
by roday
I'm trying to set up a calculated column that will give me "Age" using the difference between the dates "Today" and a date of birth. When I calculate this value, the result is in a timespan (i.e 6570.00:00:00). I'm trying to get this to convert to years but haven't had any luck. Everything I try seems to break the report. Any advice is greatly appreciated!

Re: Calculating Age from DOB

Posted: Tue Nov 19, 2013 12:54 pm
by HighAley
Hello.

We are using standard .Net Framework TimeSpan type.
Here is a description of custom format string.

Thank you.