add time-zone. change Attendance date field type to Datetime