DateDiff Formatting

Malachy39

New member
Local time
Today, 14:42
Joined
Jul 2, 2002
Messages
8
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
 

Users who are viewing this thread

Back
Top Bottom