Skip to Content
0

Select date range

Feb 22, 2017 at 08:00 PM

136

avatar image
Former Member

Is it possible in WebI to select for example 2nd,3rd,4th, value frome date column?

I mean I want to select Max([date])-2, but I can't substract days, because this column doesn't caintain day by date date. It is like:


 [Date column]

12/01/2016

05/11/2015

30/07/2015

14/05/2014
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jyothirmayee A Feb 22, 2017 at 09:16 PM
0

Hi,

Do you want to substract days from Max(Days) or display Dates apart from Max(Date) in column?.

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Like in an example substractiong days doesn't work because, in fact, I dont know dates all I want to do is to pick up eg. 2nd and 3rd row of data (which is sorted asc)

0
Kuldeep Ghosh Feb 23, 2017 at 09:13 AM
0

try and use relativedate(). Try this

=Relativedate(max([Date Objecr]);-2)

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

It is substract 2 days only.

0

opps, I misunderstood your question:

Try this:

= [Date] where([Date]<max([Date]))

0
Koen Hesters Feb 23, 2017 at 10:47 AM
0

Hi,

what 's your source, it is best to provide a filter from BEX query or from Universe

Grtz

Koen

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Universe is my source. How can I filters dates?

0
0