Null Value for a DateTime Variable

[PROKA]

How Do I set a null valuea for a date variable ?

[PROKA]

Ok , Just found out that only to a Variant u can set a Null Value :)

[Joe Mamma]

in c# (you cant do this in vb), do something like this:

 

DateTime aDate;

object aDateRef = someDateDbValue as DateTime;

 

if (aDateRef != null)

{

aDate = (DateTime)aDateRef

UseDateTimeMethod(aDate);

}

[Nerseus]

You might also consider using a "known" invalid value to represent null. For example, DateTime.MinValue.

 

Just another option - I've used both object/Variant and the DateTime.MinValue in different pieces of code. The object stuff is more readable, but requires more casting (more coding and slight loss of performance though negligable). The "known" value allows specific type casting (always a DateTime) but might require conversion when going to the DB. Also, eliminates the use of that one value for any real data. I've never had the need to store DateTime.MinValue anywhere as a valid value though.

 

-ner