BusinessObjects Board

Relativedate with challenge

building reports webintelligence
#1

Dear members,

may i ask for your very much appreaciated support? My challenge :

In the end i need to manipulate a date field with the function “relativedate()” for a simple forward simulation which works fine in general. Would you please have a look at the attached screenshot.

Based on the products listed, i would like to simulate this szenario. The smalltest date is always getdate().

=If ([product])=“Trousers” Then RelativeDate([date];-2)

Fine for me if the date listed is more than 2 days ahead. BUT if the date listed is today or tomorrow then i would have a date in the past (yesterday) which is not OK (from a forward focussed perspective)

So if the manipulated date would be smaller then getdate() i would like to have getdate() set instead of “RelativeDate([date];-2)” as a correction and that amounts for today or tomorrow would be summed up.

Any idea, PLEASE ?

Thanks a lot!
relative_date.png

ralf_cas (BOB member since 2020-08-07)

#2

at first checking if date is >= today
and depending on this result, manipulating the date with two different formulas

n8aktiv :de: (BOB member since 2018-12-29)

#3

Thanks a lot!
It was a missing paranthesis, that caused an error. Simple but made me think in the wrong direction.

Cheers!

ralf_cas (BOB member since 2020-08-07)