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
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.