James A Skipwith (4/18/2011)
Good point Mark, Date would be better here as the time portion is irrelevant. I don't tend to store many dates like this but the Date data type would be preferred over Datetime.
Most of our dates (and we have plenty) don't care about time, such as the date range that someone is covered for a particular service. The few cases where we use datetime are for fields like the last time the record was touched or when the record was created.