RapidMiner

Split date_time

Contributor

Split date_time

Good evening community!

 

Ive got a dataset whith the column date which has the format: date_time like Jan 30, 2017 12:01:31 AM CET.

Id like to extract only the date and put it into the format: "dd.mm.yyyy". Therefore, i used generate attribute with funcion date_str_custom(date, "dd.mm.yyyy").

It seems that it works like it should, but rapidminer changes Jan 30, 2017 into 30.02.2017. Any idea?

 

Thank you in advance!

 

Best regards

Kevin

 

 

 

Attachments

3 REPLIES
Elite II

Re: Split date_time

I am not sure about the problem you are reporting.  Perhaps you want to post a data sample and a process file for troubleshooting?

In the meantime, the following function (used in Generate Attributes) should actually give you the date format you want:

date_str(YourDateAttributeName,DATE_MEDIUM,DATE_SHOW_DATE_ONLY)

Brian T., Lindon Ventures - www.lindonventures.com
Analytics Consulting by Certified RapidMiner Analysts
Highlighted
Elite III

Re: Split date_time

I think it might simply be lack of capitals.  mm in this string represents minutes. 

 

Try dd.MM.yyyy

-- Training, Consulting, Sales in China, Hong Kong & Taiwan --
www.RapidMinerChina.com
Community Manager

Re: Split date_time

Yes, you need to do MM in capital letters. 

Regards,
T-Bone
Twitter: @neuralmarket