From month and and Week no form a date

sgnarkhede2016

Hello,

Want to derive the date from Month and Week no.

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

BalazsBaranyRM

Hi!

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.

Regards,
Balázs