>>>>>>Hi, I was looking for a solution to this:
>>>>>>We have a date field that if it contains a date, it means the item is closed.
>>>>>>If it is blank, it means still pending.
>>>>>>Now a new status is that it will be neither of these so a mgr wants all zeros to denote this. But it won't accept this, so what could be input to denote a 3rd status?
>>>>>
>>>>>Why not use status field?
>>>>>
>>>>>Otherwise you can either use NULL or some arbitrary date.
>>>>
>>>>How does a user input NULL?
>>>
>>>Interesting question. I don't think the user inputs it or have a way to input.
>>
>>strg+0
>
>What is strg ?
Beg your pardon. Must have been tired. Yes Ctrl+0
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]