Rapidminer displays certain times wrong after Excel import

felix_w

Dear Rapidminer Community, 

 

it's me again, yet with another problem  

 

This time I am importing data from an Excel into Rapidminer which contains dates in the format dd/mm/yyyy hh:mm. Most of the imports are correct but the software makes one mistake which is crucial for me.

 

Lets say I have a time in my excel: 23.10.2017 00:00 (which is for me midnight), Rapidminer imports this time stamp as: 23.10.2017 12:00AM. Shouldn't it rather be 12:00PM or 00:00AM? I am not a US citizen but I think 12:00 AM is definitely wrong if I want to have the midnight time, right?

 

How can I fix this problem? With a "date to nominal" operator and than somehow convert it again?

BalazsBarany

Hi!

 

This is just an artefact of the time format used by RapidMiner. 

12:00:00 AM is actually 00:00:00 in 24 hour format. You can easily check this by using Date to Nominal. Your timestamps are correct, they are just displayed in an unusual (to you and me) way. 

 

I would also prefer if RapidMiner used the ISO time format (yyyy-MM-dd HH:mm:ss) for display.

 

Regards,

Balázs

felix_w

Hi Balazs, 

 

thank you for your fast reply! Ok, this looks really odd to me but at least I can save some time reformating my table  

 

Regards

Felix