Using an SQL database, I am having trouble clearing a datefield. If I highlight and delete the existing date, I get an Invalid Date Format error.
I have tried doing it in code by making it = "" and also trying = NULL and = <NULL> but nothing seems to work.
My son-in-law reckons the best way to do it is to store it in a text field, but I'm sure there is a (very) simple answer . . . o:}