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?
BO User replied
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