Dataformatstring null date

This is a migrated thread and some comments may be shown as answers. Null dates - DateFormatString. Chris Top achievements Rank 1. Chris asked on 03 May , PM. Is there a way to set up the grid to display a blank cell for null dates. I would like this field to be blank. Thanks in advance Chris. Add a comment. Submit comment. Sort by Score Date. Pavel Pavlov Telerik team. Hello Chris, The sample project attached demonstrates how to achieve this using a custom value converter.

In the binding of the column we specify our converter. Then in the Convert method we check if the date is "null ". There is the place where you can do your custom formatting as well as I am not sure the column format string will still work with this approach. NET earlier than 3. Otherwise, the field value is converted to a string by the default conversion method before the format string that is stored in the DataFormatString property is applied.

By default, the formatting string is applied to the field value only when the data-bound control that contains the BoundField object is in read-only mode.

To apply the formatting string to field values while in edit mode, set the ApplyFormatInEditMode property to true. The formatting string can be any literal string and usually includes a placeholder for the field's value. The rest of the formatting string is displayed as literal text.

If the formatting string does not include a placeholder, only the formatting string itself is included in the final display text the field's value from the data source is not included. If the placeholder is a 0 zero enclosed in curly braces as shown in the preceding example, the field value is converted to a string by the default method.

You can append to the zero a string that specifies how the field value should be formatted. Formatting is applied by using the Format method. The number that follows the left curly brace is part of the syntax used by that method and indicates which one of a series of values the placeholder should use.

Because there is only one field value in each cell, the number that follows the left curly brace can only be set to 0. The following table lists the standard format characters for numeric fields. These format characters are not case-sensitive, except for X , which displays hexadecimal characters in the case that is specified.

You can append a number to most format characters in order to specify how many significant digits or decimal places you want to display. In most cases, formatting depends on the server's culture setting. The examples are for a culture setting of en-US. For more information and for examples that show formatting for other culture values, see Standard Numeric Format Strings. You can also create custom numeric format strings. I am stumped. Wednesday, July 25, AM. User posted This could happen if Prcnt is not a numeric field.

User posted Ok. That just might be the problem. Those columns are created by looking up integers, and dividing by them respectively, so how are they getting converted to strings? I suppose I could put an iff target is null, null, cDbl Target , but that seems like an inelegant way to handle it. Any ideas on how these are becoming strings? Wednesday, July 25, PM. Chuckanut Lighting.