Skip to Content
avatar image
Former Member

Getting other date values inbetween Min and Max date values

I have a list of start dates for children, some children have multiple start dates (2 or more)

I have been able to retrieve the Min and Max start dates where it applies to a child, i need to create a variable to be able to extract the other dates inbetween Min and Max dates where it applies to a child

can anyone please help

Many Thanks

Gabriel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 14, 2017 at 09:57 AM

    where are you trying? webi or universe?

    it easy at webi level.

    =min(date) in (child object)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2017 at 10:19 AM

    Web intelligence

    example child is got 4 start dates

    02/04/2011 05/11/2012 10/03/2014 18/06/2016

    am able to get Min Date (02/04/2011) and Max Date (18/06/2016) I need a variables to display the other two dates in seperate columns

    Child Id Start Date1 StartDate2 StartDate3 StartDate4

    500989 02/04/2011 18/06/2016

    this what is should look like, where it applies, as in where a child has more than 1 date, date should be displayed

    leave cell blank where no dates have been recorded

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2017 at 08:06 PM

    Moved to Web Intlligence Forum

    Add comment
    10|10000 characters needed characters exceeded