How to fill data in a matrix cell from type Date using a Recordset Result? SDK

[marour]

Hello together,

I have a recordset with a result of a query and i want to fill my Matrix with this result.

It works fine as long as the data is from type Text ( Edittext).

((SAPbouiCOM.EditText)Matrix1.Columns.Item("InNu").Cells.Item(i + 1).Specific).Value = rset.Fields.Item(1).Value.ToString();<br>

but once i try the same for a field from type Date or Price it didnt work and i get an errorMessage:

Date value not valid [131-183]

Any suggestions ?

[ANKIT_CHAUHAN · Accepted solution]

Hi marour,

You should set the Date value as below:

oEdit.Value = DateTime.Now.ToString("yyyyMMdd");

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[marour · Accepted solution]

This is it 🙂

Thank you dear