Date format in Matrix loaded by DataTable is shown as 20080319

[Former Member]

Hello,

I've loaded most of our matrixes with DataTables. No problems up to now. Also date columns where shown in correct B1 GUI format.

But now with a new matrix the date is 'suddenly' shown as '20080319'. When I view at B1 system information (at the bottom of B1) the column is described correctly with B1 GUI format:

U_DateEndPr (Date)

19.03.2008 [Form....Item..., U_DatEndPr]

I've made a test (one of many):

I've loaded the 'problem-matrix' with some columns (including one date column) from another DataTable which works correctly on another Matrix/Pane.

The result is the same:

In the first (correct working) matrix (pane 1) the date is 19.03.2008 and

in the second matrix 20080319

Is there something wrong with the matrix itself?

I have absolutly no idea where my fault is.

Does anybody made the same or similar experiences?

So long,

Roland

[Former Member · Accepted solution]

Roland,

the query in datatable is same for both matrixes?

[Former Member · Accepted solution]

Hello Petr,

for the test which I've made i can say yes: I've loaded the problem-DataTable with the same query as the working dataTable.

The only difference is:

The problem-matrix has less columns than the working matrix. So I couldn't bound the problem.-DataTable/Matrix to all of the query result columns.

Another hint:

The Date format '20080319' looks like the result of SDK-ValueEx (B1-DB-Format-String)

In another column beside '20080319' there's a double-value. This is shown with the correct decimal-separator of B1 (I've changed decimal sep. to '#' for test. The columns ar shown as:

'20080319' | 142#89

...so the second column is displayed correctly but the date format is still wrong...

And:

I get the same result when I do the problem-DataTable bind to exactly the same dataTable-UID as of the working DataTable.

So at the moment I suppose that the error is in the Matrix-Object. Because both matrixes are loaded by the same DataTable (for trial) and only one of them shows wrong date-format.

I forgot:

The form with the problem-matrix was made with a 2 years old screenpainter. Althogh I've made changes on the form with a actual screenpainter - could this be a problem?

Hmm, but I don't think so because on another pane and matrix of the same old form the date works corectly...

Edited by: Roland Toschek on Mar 19, 2008 1:07 PM

[Former Member · Accepted solution]

The columns in matrixes where is binded date format are both the same type?

omatrix1.Columns.Item(1).Type

[Former Member · Accepted solution]

Oooooh Petr!!

THAAANK YOU! ))

Yes: SAPbouiCOM.BoFormItemTypes.it_EDIT was the same for both matrixes...

...BUT...

DisplayDesc was TRUE in the problem-Matrix

DisplayDesc = False has solved the problem (it is set by code).

Have a nice day

Roland