We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Week Range Display In One Column

Accepted answer
40
Views
4
Comments
edited Feb 8, 2015 4:33PM in Reporting and Analytics Taleo Enterprise 4 comments

Summary

In OBI, how can I display a week date range (ex: 12/28/14 - 1/3/15) in one column

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!