Age to be calculated to the nearest Month

[nevilledhamsiri]

Dear Members,

Once Age table is created, ages in Months are getting zeros, how this will be made to nearest Month such as 0.3,0.4 etc.

Thanks

Neville

[Anil_Babu_Samineni]

Perhaps like this?

=If(Age(Today(), DATE_JOINED)>1, Age(Today(), DATE_JOINED), Month(Today())-Month(Date(DATE_JOINED)))

Or, Self satisfaction 🙂

=If(Age(Today(), DATE_JOINED)>1, Age(Today(), DATE_JOINED) & ' Years',  (Month(Today())-Month(Date(DATE_JOINED)) & ' Months'))

Image for Ref : 

[nevilledhamsiri]

Could you please please send me the formula I cannot open up the qvd

Thanks

Neville

[Anil_Babu_Samineni]

It is there in the body message 🙂

[nevilledhamsiri]

Dear Anil,

I added some more records with 2018 , then the calculation seems to be some what wrong only for those who joined 2018.

Could you please look in to this

Neville

[Anil_Babu_Samineni · Accepted solution]

Can'y you simply this, Instead AGE()?

=(Year(Today())-Year(Date(DATE_JOINED)) & ' Years') & ' ' & (Month(Today())-Month(Date(DATE_JOINED))) & ' Months'

[nevilledhamsiri]

Thanks Anil,

This is ok now.

Neville