topic Re: Convert days into years months days in QlikView

Convert days into years months days

Wed, 26 Apr 2017 13:38:23 GMT

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 — Wed, 26 Apr 2017 15:51:45 GMT

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