Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following column, which have the datatype $numerci $integer. One column stands for the calendar week and the other for the year.The Date should always be the first day in this calender week.
Week | Year | Date |
6 | 2022 | 07.02.2022 |
7 | 2022 | 14.02.2022 |
How would one solve this in the data load editor ?
What exactly is the issue you're trying to solve?
If you're trying to create the Date column from the Week and Year columns, try:
MakeWeekDate(Year, Week) as Date
What exactly is the issue you're trying to solve?
If you're trying to create the Date column from the Week and Year columns, try:
MakeWeekDate(Year, Week) as Date
Thanks that was exactly the solution I was looking for!!