What is the date format of "Apr 01, 2011 1:30:00:000 PM ICT"

NAK_1

Hello, I am quite new to RapidMiner here. I would be very much appreciated it if you could help me out with this date format. I have tried this format >> MMM dd, yyyy  HH:mm:ss aaa z and the system said that it cannot parse the data with this date format. Thanks

Caperez

Hi @NAK_1, 

for that date the format is quite well, but you need to change the aaa for milliseconds by SSS, i.e MMM dd, yyyy  HH:mm:ss aaa z for MMM dd, yyyy  HH:mm:ss sss z.

Best