Week Range Display In One Column
SummaryIn OBI, how can I display a week date range (ex: 12/28/14 - 1/3/15) in one column
I'd like to show a week date range (ex: 12/28/14-1/3/15) in one column (great for pivots and charts). I've focused my attempts using WEEK_OF_YEAR but I'm not having any luck (I'd rate my SQL skills at 3 on a scale of 1-10)
I've searched around but all I can find are examples of the First Day of the Month (which is great but not what I need). Any help would be greatly appreciated.
Using OBI with Taleo.
Thank you for your help.