change Event date type
-replace day, month, and year columns with date
-store dates using datetime datatype