Skip to Content
avatar image
Former Member

Select date range

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 22, 2017 at 09:16 PM

    Hi,

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

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed 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)

  • Feb 23, 2017 at 09:13 AM

    try and use relativedate(). Try this

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23, 2017 at 10:47 AM

    Hi,

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

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded