Overlapping Range Check

Question

Hi, 
 There are two date fields in database 'startDate' and 'endDate' for every record. I want to check overlapping conditions while user try to insert new set of date range for a new record. For eg. if we had 'startDate' and 'endDate' as '20 Dec 2019' and '5 Jan 2020' respectively, we cannot add new 'startDate' and 'endDate' as '25 Dec 2019' and '15 Jan 2020' because it is overlapping.

Chris · Accepted Answer

I believe there is one additional scenario to consider, when an existing range starts after the start date and ends prior to the end date (provided dates surrounding completely). All can be covered by reducing to one scenario: 1. An existing range starts <= to the end date you provided and ends >= the start date you provided a!queryEntity( entity: cons!, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "startDate", operator: "<=", value: ri!newEndDate ), a!queryFilter( field: "endDate", operator: ">=", value: ri!newStartDate ) } ) ), fetchTotalCount: false )

Overlapping Range Check

Top Replies