Page 1 of 1

Calculating Age from DOB

Posted: Mon Nov 18, 2013 9:32 pm
by roday
I am trying to create a calculated column that will give me age by finding the difference between today's date and a date of birth. The difference is outputted in a timespan (ie. "6570.00:00:00") I need to convert this to years but everything that I try breaks the report. Any advice is greatly appreciated. Thank you.

Re: Calculating Age from DOB

Posted: Tue Nov 19, 2013 6:29 am
by HighAley
Hello.

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

Thank you.