Convert days into years months days

[#1]

Hi,

I have a field in a table which has the no. of days

Consider Days_age as 400 days,

We should convert it as 1 year, 1 month, 5 days as the output.

So how do we achieve this in script?

[antoniotiman]

Hi,

I assume = Year = 365 days and Month = 30 Days.

Try

=Floor(400/365)&' - '&Floor(Mod(400,365)/30)&' - '&Mod(Mod(400,365),30)

Replace 440 with Your Field and - with Text

Regards,

Antonio