>I'm running a bit slow today.
>
>Am I correct in thinking I should use nulls?
>
>If I use 30/12/1899 I would have to convert that every time I wanted to use it wouldn't I?
As I understand it, the ideal solution would be to forget about using empty dates, i.e., redesign your application in that respect. Any empty date should be converted to NULL before sending it to the server.
The solution to check for a specific date is not ideal, because you might conceivably use that date in a real application.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)