Skip to Content
0
Former Member
Jul 29, 2016 at 06:39 AM

Date Range

27 Views

Hi All,

I have this question below.

I have a main report which will pull out an event.

In the Event table, it have a StartDate and EndDate.

I have create a sub report to show a concurrent event.

I passed Startdate and EndDate to the sub report as parameter.

Will like to know how can I write the code in the subreport of Select Expert to only select concurrent Event which Start and End date follow with the Main Event Start Date and End date.

Example:

Main Event --> Start Date: 29 July 2016, End Date: 2 Aug 2016

Event A --> Start Date: 30 July 2016, End Date: 30 July 2016

Event B --> Start Date: 2 Aug 2016, End Date: 3 Aug 2016

Event C --> Start Date: 28 July 2016, End Date: 3 Aug 2016

Event D --> Start Date: 28 July 2016, End Date: 30 July 2016

Event E --> Start Date: 28 Aug 2016, End Date: 28 July 2016

In the Concurrent Subreport, Event A, Event B, Event C and Event D will show.

Event E will not show.

This is what i wrote but not complete.

({EV200_EVENT_MASTER.EV200_EVT_START_DATE} in {?Pm-EV200_EVENT_MASTER.EV200_EVT_START_DATE} to {?Pm-EV200_EVENT_MASTER.EV200_EVT_END_DATE} OR

{EV200_EVENT_MASTER.EV200_EVT_END_DATE} in {?Pm-EV200_EVENT_MASTER.EV200_EVT_START_DATE} to {?Pm-EV200_EVENT_MASTER.EV200_EVT_END_DATE}) and

Can advise how can i complete this code?

Thanks.

Regards,

Mavis