Dateadd equivalent in Webi reporting

[Former Member]

Hi,

I need to do some date manipulations in Web Intelligence on the reporting side - at least until our developers add some additional items to our universe. Is there a way to add hours and/or minutes to a time - say to move it one hour ahead? I know that in sql it's simple to use dateadd or similar but not sure how to do it in webi.

While I'm asking, is there also a datediff equivalent?

Thanks!

John

[Former Member · Accepted solution]

The Function in WebI is RelativeDate(date input_date; integer num_days ).

It returns the Date that is Input date + number of days.

For adding time, you can divide a day by hours/seconds.

eg : RelativeDate(ExampleDate;0.004)

ExampleDate = 01/01/01 2:00 PM

New Date = 01/01/01 2:05 PM

[Former Member · Accepted solution]

Awesome! Thanks. I had found the relative date but hadn't thought that I could use a decimal value. You are my new hero!