How to use Spotless Data?

Date Validation

Dates are validated as follows:


Blank records may either be checked or skipped.


The range of dates may either be specified as a fixed window (e.g. between 2016-01-01 and 2017-01-01 or as a following window based on a number of days from the date when the job is run. Range checking is optional and may be skipped.


The date format supports the following characters for date formatting:



If strings fall outside the prescribed characteristics the following options are available: