Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Setting Date in a Matrix

Hi All,

I have set a Current Date in a Matrix Column but its not displaying the current date. The code i used follows :-

oCriticalDB.SetValue("U_insdate", oCriticalDB.Offset, Date.Today)

Please tell what should i change in it.

Thanks in Advance.

Regards,

Madhavi.

replied

Hi,

it's again the old problem with the SDK-Var-Types.

Try with formatting your Date.Today to a String in "20081014"-Format: At the last parameter SetValue expects a String!

oCriticalDB.SetValue("U_insdate", oCriticalDB.Offset, "20081014")

For me the following rule has worked perfect in most (I would say nearly all) cases:

Have a look at the automatic help of .NET while typing a SDK-function:

If SDKs Get/Set-Value, ValueEx, Value etc... expect/return a string then format your value in - I call it - SDK-DB-format:

Price, quantity etc. => "1234.23" (this works for every language setting of B1 - also for germany where the dot normally is a comma

Date => "20081014"

If SDK expects/returns an object, then there's a good chance that you can use the .NET-Var-Type that you expect as a programmer:

Price, quantity etc. => Double

Date => DateTime )

I forgot: This only works when the field is DataBinded to a DataSource of the corresponding format!!

Is your U_insdate really a Date in DB?

Edited by: Roland Toschek on Oct 14, 2008 10:18 AM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question