Hi all,
I've calculated the difference between 2 dates in a formula in a Bex Query which resulted in the total number of days.
Now I would like to display this result into number of years, months and days, if possible.
In Excel there is a function called DATEDIFF but in Bex I can't find a similar funcionality.
Does anyone know how I can convert e.g. the number 1502 into 4 years, 1 month and 11 days?
(I used FM ZHR_HK_DIFF_BT_2_DATES to get that result).
Thanks for your iinput!
Mark