I am trying to upload my excel file with date and time to run the event log / process mining. The date and time format in the excel file is yyyy-mm-dd hh:mm:ss but Celonis does not recognise this and is calling it out as the wrong data format type?

Hi Sherissa,

What error are you getting? When you upload the Excel file, did you try to change the data type and format using the Celonis UI?

Maybe, you can try to export the Excel file as csv.

Hello @sherissa.sukar ,

I encountered a similar issue before, but I discovered that when assigning the activity configuration, the focus is on the eventtime field, which is displaying the wrong data type. However, when you initially open an activity configuration, it is searching for CASE_ID, and as EVENTTIME is in date format, it appears as the incorrect data type.

Therefore, please select the Aase ID and Activity name, and then check for Event time. I hope this resolves your concern.