If I understand it correctly, this is what we can do.
But still using a master Calendar. See if this works for you.
sample3.qvw 182.8 K
try to use a master calendar.
Day(DATE) as Day,
DayName(DATE) as [Day Name],
WeekDay(DATE) as [Day of Week],
WeekName(DATE) as [Week Name],
LunarWeekName(DATE) as [Lunar Week Name],
Month(DATE) as [Month],
MonthName(DATE) as [Month Name],
QuarterName(DATE) as [Quarter Name],
Year(DATE) as [Year].
We use master calendar to make a proper association between all the date field in all the table.
You can also use autogenerate for creating the master calendar.
But in your case try to create master calendat from the approach you find better.
Hope this helps you