From month and and Week no form a date

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II

Want to derive the date from Month and Week no.

Month Feb
Week no 2 
So from any date from 2nd week like 9Feb2023


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

    The easiest way to do this is getting a list of dates for the possible date range, extract the required attributes from the date, and join on your data. 

    List of dates: Generate Data, Generate ID, Generate Attributes with date_add()

    Extract the required attributes: Generate Attributes or possibly Date to Nominal or Date to Numerical, depending on the format of existing data.

Sign In or Register to comment.