Master Calendar when only a year and week number is available
I'm wondering if it is possible to create a master calendar from a table that only has years and week numbers in it? Or any way else get the months, quarters etc out? All the tutorials I've watched already have a proper date to use as a starting point for the calendar.
I've also tried the Monthname(MakeWeekDate(Year, Week)) but it is not working for me.
Re: Master Calendar when only a year and week number is available
the problem turned out to be that QV read the week numbers to be text instead of numbers because of the form of the source data. After I turned them to numbers the normal MakeWeekDate worked just fine.