• I have found it more important to understand how the tools my users use interpret date and time fields. Some older but widely used tools don't work well with Date and Time fields and smalldatetime or DateTime is the only field type they can dependably use.