substracyt 1 hour from date in webi

[system]

Hi I want to substract 1 hour from date.

For example date is 20 Jan 2014 04:22 00 AM
I want output 20 Jan 2014 03:22 00 AM

Thanks in advance.

---

rbnp (BOB member since 2014-05-08)

[system]

Hi,

Maybe this old topic 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)

---

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

[system]

Thanks for reply…
But Its not working… I am using BO webi 3.1

---

rbnp (BOB member since 2014-05-08)

[system]

@rbnp

But Its not working… I am using BO webi 3.1

What exactly is not working?

---

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