Pass Null Value for Time in Matrix

[Former Member]

How to pass NULL value for Time in Matrix?

When populate data, that cell should blank if there is no Time inserted?

Field Data Type is Hours

[Former Member]

Hi..

Try this one

Edittext= OCol.Cells.Item(Column-ID).Specific = Nothing

OR

Edittext.Value = Nothing

Regards...

Billa 2007

[Former Member]

Hi Billa,

I used this one

oMatrix.Columns.Item("colStpTime").Cells.Item(i).Specific.value = Nothing

oMMDocument.UserFields.Fields.Item("U_StpTime").Value = oMatrix.Columns.Item("colStpTime").Cells.Item(i).Specific.value

But by default 0 goes in the table so in matrix shows 12:00AM

I required blank cell in matrix.

If I update U_StpTime by backend as NULL then the matrix shows blank.

But how to pass NULL by coding?

[Former Member]

hi Mahesh,

oEdit.text=""

regards,

varma

[Former Member]

Hi,

By your answer in table bydefault value goes to 0 so in matrix it displays 12.00AM

I want blank in Matrix cell.