>it definetly is not being stored as a NULL value. IF I reset it to NULL afterward it shows as BLANK on the screen, but when the value is BLANK (not null) it gets saved as 01/01/1900
Use validation on the control to change the empty date to a null, then it will store a null date to SQL. SQL has no concept of what an empty date is.
IF EMPTY(This.Value)
This.Value = .NULL.
ENDIF
RETURN DODEFAULT()