The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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
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