conditional formatting check for that date is null.

[Ole]

Hi,

I have a problem , I can not figurer out / it is not working how to change the background when a date field is not set.(is null)

Here is what I have come yp with so far.....

realizing that the datetime value will be datetime.minvalue when the underlying data is null, I made the following in an formatting rules expression.

=Fields.SyncDate.Date.Ticks < :=1  but nothing happens, 

Any ideas on how to make this happen ?.

Best Ole

[Peter]

Hello Ole,

Generally for checking null data our suggestion is to use the IsNull(Expression, ReplacementValue) build in Function that checks an expression and either returns the checked expression or a replacement value. 
Thus your formatting rule should look like:

Expression	Operator	Value
= IsNull(Fields.SellEndDate.Ticks,0)	=	=0

All the best,
Peter
the Telerik team