The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

Getting parts of a date

SimonW18272SimonW18272 Member Posts: 13 Newbie
Hello together.

I got a question. When I want to create a new attribute I have the following problem.
I have a date which is in forma contaning month, day, year, time.
However I just want to extract the Month and the year so that the format is YYYY:MM

I found in the internet only the 



However I am now courious if it is easily possible to get also the year within this operator so that I have the YYYY:MM of the att1

My operator should look like
However it isnot possible this way.

Can someone help me to keep the date format (not nominal/...) and just the year and month in one attribut



  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

    Year and month are two numerical attributes. How would you represent them in one numerical attribute?

    If you need them in one attribute, you need to convert them to a nominal attribute. The formula for that is date_str_custom(Att1, "yyyy:MM").

  • Options
    SimonW18272SimonW18272 Member Posts: 13 Newbie
    Thanks a lot! By adding the sort operator I can finally use this to see a monthly overview of my data :) Thanks a lot!!!
Sign In or Register to comment.