In my chart, i see my REPORT_DATE (date field) automatically parsed for Y, Y-Q, Y-M, and Y-M-D. Is there any "by week" option somewhere? or would i Need to include a week reference in my actual data in another column?

This message has been edited. Last edited by: FP Mod Chuck,

You can add week to your synonym. Open the synonym in the editor and insert a new field that extracts what you want. There are two Week formats:

  
ORDERDATE_weekday/W =DTPART(ORDERDATE, WEEKDAY);
ORDERDATE_weeknum/I9 =DTPART(ORDERDATE, WEEK);

I am able to make the WEEK i9, however how can I add in the year to that? When i use the | it says numeric where alpha is required.

DTPART(REPORT_DATE,YEAR) | DTPART(REPORT_DATE,WEEK)

You can only concatenate alpha fields. So, first convert the Year and Week to Alpha and then use Pipe to concatenate them.

Or if both fields are numeric, you can do as following

YRWK /I6 = YEAR * 100 + WEEK;