Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ReportNet Age vs Years_Between function

Status
Not open for further replies.

JKas

Programmer
Jan 20, 2005
28
US
Hello,

I tried using the _age function in ReportNet 1.1 as follows (where Birth Date=1/26/84):

_age([Birth_Date])

The returned value was 210,225. I even tried formatting the column differently.

I then used the _years_between function and it returned the correct value of 21.

The years between even correctly calculates the age when the birth date is great than today's date.

I can use the _years_betweeen function. My question is related to the Age function.

Is this working as designed, or should it have returned the value of 21 as well?

Thanks

JKas
 
As per the documentation it is working fine returning age in YYYYMMDD format as 21 years 02 months and 25 days for your case.

You need to format it or use some funtions to display accordingly..

Regards
K
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top