Skip to Main Content
Best Practices 1 and 2 for Validating Data Sets
- Program valid ranges for inputting data into fields when applicable.
For example, do not allow an age greater than 150 years or only allow numbers to be entered into numeric fields.
- Apply data types to fields to prevent reformatting.
For example, set up date fields to only accept dates rather than setting them up as free text fields.