age

[Malachy39]

I created a field called Age in a query.

I built an expression...
Age: DateDiff("m",[Installed],Date())

It successfully returns the correct number of months.

But how do I make it show a different format, i.e instead of 48 months it returns 4 years, instead of 43 months it returns 3 years and 7 months?

thanks and have a jolly good day

 

[RV]

Search the forum for this frequently posted topic.

RV

 

[Alexandre]

Format(Date()-[DOB],"yy mm")
Would return for example 01 03 for one year and three months

 

[Malachy39]

Age

Thanks so much. I even added the following:
Format(Date()-[Installed],"yy"" years ""mm"" months""")

So that it returned....
03 years and 04 months.

Pretty cool!