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')
>>>> '&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,