Dateadd equivalent in Webi reporting


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?




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

0 View this answer in context