Select date range

[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

[kohesco]

Hi,

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

Grtz

Koen

[Former Member]

Universe is my source. How can I filters dates?

[kohesco]

Hi,

check out

http://www.forumtopics.com/busobj/viewtopic.php?t=152613

Grtz

Koen

[former_member198519]

try and use relativedate(). Try this

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

[Former Member]

It is substract 2 days only.

[former_member198519]

opps, I misunderstood your question:

Try this:

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

[jyothirmayee_s]

Hi,

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

Thanks,

Jothi

[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)