🎉 🎉   RAPIDMINER 9.5 BETA IS OUT!!!   🎉 🎉

GRAB THE HOTTEST NEW BETA OF RAPIDMINER STUDIO, SERVER, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

how to split date

halaalrobassyhalaalrobassy Member Posts: 14 Contributor I
edited July 19 in Help
i have date and time attribute, i want to split the date into new column , how can i implement this operation 
thank you
Tagged:

Answers

  • kaymankayman Member Posts: 396   Unicorn
    edited July 19
    Use the generate attribute operator.
    In this operator you will have quite some options to play with dates, including one to select only part of the date (date_get), just 'overwrite' your current field with the newly generated.

    Alternatively you could use the split operator and split on space. However, this would mean you need to convert your date to a nominal first, and afterwards convert to date again so it's a few extra steps compared to the generate operator
    varunm1halaalrobassy
  • varunm1varunm1 Moderator, Member Posts: 840   Unicorn
    Hello @halaalrobassy

    Generate attribute with function date_str_custom(date, "dd.MM.yyyy") should work. Replace date with your date attribute name.
    Regards,
    Varun
    Rapidminer Wisdom 2020 (User Track): Call for proposals 

    https://www.varunmandalapu.com/
  • halaalrobassyhalaalrobassy Member Posts: 14 Contributor I
    thank you
    also, i used date_str_custom(att,"dd/MM/yyyy") and worked with me
    varunm1
Sign In or Register to comment.