Skip to Content
Former Member
Dec 20, 2006 at 08:01 PM

Display date as CalMonth/Year



We have a DSO with several date characteristics. Example - Open Date, Recived Date, Actual Delivered date etc.

There is a requirement to run a summary report by month for these dates.

Example - by Month on Delivery Date would be

Sales Value1 05/2006

Sales Value2 06/2006

My question - with out having to create a Cube and rolling up data - is there a way to report of a DSO but show the corresponding date as CalMonth/year format.

I am aware of creating a variable of restricting dates by period but not sure if I can actually display any specific date as MM/YYYY.