cut down item creation and record time to daily resolution, refs #87

database schema changes and conversion from datetime to date type is still
missing