cancel
Showing results for 
Search instead for 
Did you mean: 

Is there an equivalent RelativeTime function like Relative Date in Webi?

Former Member
0 Kudos

I am in need of a RelativeTime function just like RelativeDate functions.  This way I can say give me something in the last 8 hours based on a timestamp field.  If we can put this in the universe, even better but for now in Webi at least.  Does this exist for 4.0 or later and is it coming?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

you can use the relativeDate function of webi to calculate hours on a timestamp, e.g. with following function you can add 8 hours:

=RelativeDate([Sale Date];0.834)

Afterwards you can do the filtering with some variables.

You can also use the corresponding database function of the DB behind your universe to create a predefined filter on the universe.

BR

Former Member
0 Kudos

Hi Victor,

We tried as per your instructions but it was throwing an error.

we would like to subtract 3 hours from one of the date variable.

Could you please advise us.

Thanks for your Help In advance

Regards!!

Answers (0)