From month and and Week no form a date
sgnarkhede2016
Member Posts: 152 Contributor II
in Help
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
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
0
Answers
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