Assign null to DateTime data type

[Antzz]

Hi Folks,

Any idea on how to assign a null/empty value to a DateTime data type? If this is not possible then what is the alternative

Thx and appreciate it.

A

 

[MasterRacker]

I ran into the same problem here: thread732-1090257

Basically you need to pick a date value that will represent null since .NET DateTimes are not nullable.

<sub>Jeff
[purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day

"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me</sub>

 

[JurkMonkey]

DateTime.MinValue is a good way to check for a bad date. If a date is supposed to be null, I set it to MinValue.

 

[MasterRacker]

That's what I ended up doing as well. Actually, I ended up with 2 "special dates".

NullDate = DateTime.MinValue
ZeroDate - 01/01/1990 (place wasn't around before then)

This allowed me to distinguish between an empty date and "the beginning of time".

<sub>Jeff
[purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day

"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me</sub>