General Principles

Dates

Date format will always be YYYY-MM-DD for character fields, and YYYYMMDD for integer fields.