Week/Year for X-Axis

[#1]

Hi:

Can't seem to find a previous discussion on this. I currently have a variable created in the script to give me YEAR_MONTH

Which works great. Seeking to do the same to add to a Cyclic Group dimension for a series of charts and thought I was home free with this, which loads without error: 

date(WeekStart(APPROVED_DATE),'WW-YY')) as APP_YEARWEEK

But the resulting field shows me, which looks right except for the 00.

Document format is

What am I missing?

thanks in advance.

Jim

[sivarajs · Accepted solution]

trim(date(TempDate,'WW-YY')) as APP_YEARWEEK

[#3]

Thanks, this works, though sorting seems to be a problem. I'll work it out.

[#4]

and your sort suggestion worked as well. Thanks for your help.

[sivarajs]

Give SubField(wk_yr,'-',2)&SubField(wk_yr,'-',1) as your sort expression to sort asc or desc by week and year