DateTime

[Adam K.]

i have a bunch of user input cells that i want to show dates. i am using a virtual grid.

i tried using format = "d" but the cell defaults to 1/1/0001.

can you change that so it defaults to "" but when a user types in a date it then formats it to the "d" format.

thanks,
ak

[Administrator]

>>virtual grid.
In your virtual grid''s QueryCellInfo, what does your data source provide in this case? It looks like it provides a zero. In this case, you might try setting e.Style.CellValue = DBNull.Value or maybe set it to null to see if that will give you the behavior you want to see.

If not, if you will explain what value your data source is supplying in this case, and how you are setting the CellType and CellValueType for this cell, then maybe we can suggest something else.