Hi,

I'm new to DNN and User Defined Tables.... perhaps you can help!?

I have a Date of Birth column which is obviously set to date type. I have another column for "age". This column is set up as a calcuated column. Is it possible to work out the age using an expression?

If so please advise?

Many thanks

Hi Sebastian

Thanks for your comments. I've read posts about hidden fields etc... But i'm not sure I even need that?

What I've come up with so far is the following expression:

([Ticks:Now] - [DOB_UDT_Ticks]) / [Ticks:TicksPerDay] / 365

Where [DOB_UDT_Ticks] is the token of my DOB column. My D.O.B is #04/15/1978# which makes me 29 years old today, however the formula rounds up to 30.

Does anyone have any ideas how to stop the expression from rounding up? I think this could be possible using the output format, but not sure how?

Any ideas??

Thanks

Try:
([Ticks:Now] - [DOB_UDT_Ticks]) / [Ticks:TicksPerDay] /365.25 -0.5

-0.5    handles rounding issues
.25     includes leap years into calculation (also only an approximation)