Returning the duration in Years/Months

[GavinDJ]

Hi There,

I've got a list of sessions, with the date and I want to return how long the client has been in the practice.  I've got the column type set to duration, and I'm using this expression. It seems to be returning the amount of hours. 

Max(
SELECT(
client log[Session Date],
[client code]=[_THISROW]))
-
Min(
SELECT(
client log[Session Date],
[client code]=[_THISROW]))

I'd like the returned value to be X years and Y days.

Any suggestions are warmly welcomed.

Gavin

[WillowMobileSys · Accepted solution]

AppSheet does not have functions that provide this result. You will need to calculate this.  The easiest is probably to use the TOTALHOURS() function and then divide hours in a year to get # of years.  Then divide the remainder by hours in a day to get # of days.