Skip to Content
0

Getting other date values inbetween Min and Max date values

Jul 14, 2017 at 09:54 AM

57

avatar image
Former Member

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

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

3 Answers

AMIT KUMAR
Jul 14, 2017 at 09:57 AM
0

where are you trying? webi or universe?

it easy at webi level.

=min(date) in (child object)

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

web intelligence


0

try this.

=min(date) in (child object)

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

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

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

don't know how many columns do you have in the table.

if limited then try with Horizontal table.

0
Jacqueline Rahn
Jul 21, 2017 at 08:06 PM
0

Moved to Web Intlligence Forum

Share
10 |10000 characters needed characters left characters exceeded