<div>
I have changed the default on that field in the table, then changed all the null values that were present.<br />
This will also prevent future squabbles when dealing with that field in the future.
</div>


I have changed the default on that field in the table, then changed all the null values that were present.
This will also prevent future squabbles when dealing with that field in the future.

<div>
<div class="content wysiwyg-content">
I have a GridView being populated using a SPROC in SQL SERVER 2008 in an ASP.NET app.<br />
In the grid two fields are being compared.<br />
PromisedDate &nbsp;and &nbsp;ShippedDate<br />
<br />
both are datetime <br />
<br />
If &nbsp;ShippedDate&gt;PromisedDate &nbsp; the color of the background of that record is changed to red.<br />
<br />
Up to this point the PromisedDate has not been used, and there are lots of 'NULL' records.<br />
How can I handle the NULLs in this situation of a datetime?
</div>
</div>


I have a GridView being populated using a SPROC in SQL SERVER 2008 in an ASP.NET app.
In the grid two fields are being compared.
PromisedDate  and  ShippedDate

both are datetime 

If  ShippedDate>PromisedDate   the color of the background of that record is changed to red.

Up to this point the PromisedDate has not been used, and there are lots of 'NULL' records.
How can I handle the NULLs in this situation of a datetime?

Handleing NULLs when performing a comparison between two datetime fields

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.