Excel to Bo conversion

[system]

Hi

The below are the excel formula and i need to convert in to BO webi report. I tried with releative function but i didn’t worked for me.

(DATE(YEAR(C4),MONTH(C4),DAY(C4)))+8/24

Please help me to convert.

Thanks,
Stalin

---

stalint (BOB member since 2004-12-14)

[system]

Hi,

Which BO version do you use?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

BOXIR2 sp2. Also the above excel function covert the nearst business working hrs.

---

stalint (BOB member since 2004-12-14)

[system]

Please post the code that you tried.

---

Jansi (BOB member since 2008-05-12)

[system]

=If(FormatDate([Open Date];“hh:mm:ss”)<=[TimeValue];RelativeDate([Open Date];[v1]))

v1=8/24 and
TimeValue=FormatDate([Open Date];“hh:mm”)

---

stalint (BOB member since 2004-12-14)

[system]

Hi,

As far as I remember, the RelativeDate() function did not work with fractions of a day in BO XI r2. Only with full days.

However, it does work in BO XI 3.1.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

is there any way to implement the above excel function in boxir2 sp2

---

stalint (BOB member since 2004-12-14)

[system]

This can get you started:

Changing the time portion of timestamp

Hi I just wanted to add an hour with my existing timestamp, your input is more appreciated. I wanted to do this only on the Report and not on the universe. Say the time in the column 14-08-2009 14:30:00, i wanted to display it as 14-08-2009 15:30:00 Regards Siva.M looksmee (BOB member since 2006-02-08)

Good luck.

---

Marek Chladny (BOB member since 2003-11-27)