Session Validation

Where two or more date fields with the same format are present in a field, Spotless wills search for possible session validation rules. Session data consistent of two dates (a session start and a session stop) and a key field that corresponds to the entity that the sessions relate to.

 

Spotless provides for checking for both gaps and overlaps.  A threshold number of seconds can be specific such that very small gaps and overlaps may be ignored.


The options for resolving gaps and overlaps are as follows:

 

Gap checking

 

 

Overlap checking