Skip to Content
0
Former Member
Jan 24, 2013 at 11:55 AM

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

25 Views

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