Day and Year

[Anonymous]

I have a bar chart whose Dimension is WeekYear (coming from Calendar table),

I need to plot (or display) it against Day And Year without losing above functionality. Calendar table currently does not have Day and Year concatenated.

[swuehl · Accepted solution]

If your week is an ISO week, you can use this function:

MakeWeekDate(YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

Examples:

makeweekdate(1999,6,6) returns 1999-02-14

makeweekdate(1999,6) returns 1999-02-08