add end datetime to event table