Display a duration in months

[#1]

Hello,

I looked at function "interval" and its formats.

I'd like to display a duration "in months" between 2 dates ?

I don't know why but the expression I wrote doesn't give the right answer ...

Here it is :

>>>> '&interval((Now() - Min(TKT_CHANGE_DATE)), 'MM hh:mm')

or

>>>> '&interval((Now() - Min(TKT_CHANGE_DATE)), 'MM')

the hours hh:mm are ok, but the values in days are > 30, and values in MM it still 0 ... in both cases !

What is wrong ?

Thanks a lot for your help,

Olivier

[Anonymous]

Oliver,
MM format doesn't work with interval function. It accepts only days (DD), hours(hh), minutes(mm), and seconds(ss). I assume it is so because month is not a constant time span.
You can use intrval in days divided by 30, or use a more complex logic if really necessary.