This content has been marked as final. Show 4 replies
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.