How to use Spotless Data?

Session Validation

Where two or more date fields with the same format are present in a field, Spotless will search for possible session validation rules. Session data consists 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