[RESOLVED] Handle Nullable Date Field with DateTimePicker

[kvwarun]

Dear All,

Which is the best pratice to handle a Nullable Date Field with DateTimePicker control. From my previous experience i learned that we could not show Null in datetimepicker control, i used to fix this problem with IIF function. can anyone help me out to solve this problem in a better way

Warun

[dglienna]

It's been asked:

http://www.codeproject.com/KB/selection/NullableDateTimePicker.aspx

[kvwarun]

Thanks for your suggestion. I solved the same by setting
DateTimePicker1.Format = Custom
DateTimePicker1.CustomFormat = " "

this case your DateTimePicker control shows blank in display, and whenever user select a particular date, i set the custom format to appropriate expression. pressing delete key set the customformat again as " ". so the space we can treat as Null and not space you can consider as datetime value

Warun