Descending "yyyy-mmm" column in BO v4 not working

[Former Member]

I need to create a table where 1 column is a descending date value as follows:

Jan-2013

Dec-2012

Nov-2012 and so on....

In BO Xir3 this was accomplished with the following:

=ToDate(FormatDate([<a database column>];"mmm-yyyy");"mmm-yyyy")

I cannot get the equivalent to work in BO v4.

Applying the same function call as above produces a list of:

01/01/2013

01/12/2012

01/11/2012

so the incorrect format as I need no leading 01's and a character month.

The statement =FormatDate([<a database column>];"mmm-yyyy")

will produce a character string list of

Sep-2012

Oct-2012

Nov-2011  A character string version of the date, but the date will be sorted in a non-sensible order.

Applying the ToDate funtion to it to create a recognised Date field creates the incorrect list

01/01/2013

01/12/2012

01/11/2012

BOXIr3 did not require a separate date column to be created and hidden etc the formatting shown above was sufficient

[Former Member · Accepted solution]

Hi Michael,

The calculation engine has differences between XI R3 and BI 4. You can look at the below article

http://155.56.92.22/wiki/pages/viewpage.action?pageId=293666958. So you might have to implement work around as you mentioned using a hidden column to get you desired sort.

Thanks,

Tauseef