AnsweredAssumed Answered

Preventing overlapping dates

Question asked by duncanbaker on Apr 24, 2015
Latest reply on Apr 24, 2015 by duncanbaker

Hey folks

 

I'm after some different ideas on how to prevent overlapping dates. Here's the scenario. I have records that have start date and end date fields - the records represent a period of time. Examples:

Record 1: 1/1/2015 - 2/28/2015

Record 2: 3/1/2015 - 4/30/2015

 

I want to prevent someone from coming along and making:

Record 3: 3/30/2015 - 5/31/2015

or

Record 3: 12/1/2014 - 1/31/2015

i.e Dates that fall within a period that belong to another record. Each record should represent a unique set/range of dates.

 

I have validation scripts that check other things when a user hits a save button, so it would happen in the script rather than in field definition validation.

 

Any thoughts? Many thanks.

Outcomes