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: