10 Replies Latest reply on Apr 24, 2015 7:49 AM by duncanbaker

    Preventing overlapping dates

    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.