Duplicates that have no value

[gemma-the-husky]

With regard to the issue I mentioned, I ended up using datevalue of zero for an "any date", but then had to test for the special case of zero. Instead of users then seeing a blank for the "required date", they see a 1899 date, which was not ideal.

 

[Deleted member 147267]

I think you would probably agree that allowing ZLS in a field like company name is just wrong.

I do and you are correct that I would not design from scratch that way. Having had the experience, I'd NEVER say NOT now.