Date group formatting by week. — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Date group formatting by week.

edited Oct 29, 2011 4:54PM in Reporting & Analytics for B2C Service 6 comments

Content

Hi,

 

I am grouping data into reporting weeks by using the syntax below: date_format(transactions.created,'Week: WW MONTH YY').

 

This is displayed as "Week: 34 August 2008". What I would like to do is display the date range of that week rather then the number i.e. "01-08-08 August 2008".

 

Is this possible?

 

Thanks,

Aaron

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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