Can you explain how this is done? We selected the Event Date Column for data format and entered custom date format of dd-MMM-yy h:mm:ss tt. The result was the correct date with the same hour minute for every transaction of 12:00:00AM.