Skip to Content
1
Former Member
Nov 25, 2011 at 12:53 PM

Convert number of days into yy.mm.dd in Bex Query

214 Views

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