DATEDIF function in Business Objects

building reports webintelligence
1

Hi Guys,

Any idea how I would build the below excel formula into Business Objects?

=DATEDIF(E5,TODAY(),“y”)&" years, “&DATEDIF(E5,TODAY(),“ym”)&” months"

This is giving me a headache!

Thanks in advance for you help!

Kind regards

jess

jh362@hotmail.com (BOB member since 2015-02-27)

2

As always best to start with the business requirement :wink: .

What is that formula doing in Excel in English…

For example:-
Calculating the difference in years from today…etc

Mak 1 :uk: (BOB member since 2005-01-06)

3

Hi Mak,

Appologies! I am trying to calculate the difference in both years and months between two dates.

Thanks

Jess

jh362@hotmail.com (BOB member since 2015-02-27)

4

Not as easy as it seems, although this post may help you…

https://bobj-board.org/t/196104/4

Mak 1 :uk: (BOB member since 2005-01-06)

5

Send me a PM with the explanation of the dates and the variable names and I will create the variable for you. Doesn’t seem like it would be to hard to sort out.

vunoo :australia: (BOB member since 2015-04-04)

6

It’s very easy,if you have the two variables like date1 and date2 then to calculate the months and year difference use below formulas.

Months
=MonthsBetween([date1];[date])

Year

=Year([date1])-Year([date2])

deepsloading (BOB member since 2015-02-07)