Custom date format creates visible default value?

[rakilgore]

When using a predefined date format for a field, I get null values in the
table and controls in forms as expected. But when I use a custom format in
the field definition (e.g. mm/dd), I get 12/30 as default values even though
the default value field is blank.

Why is this and what is the suggested workaround? Setting the default value
to null did not work.

 

[rakilgore]

Solved. The field was inadvertently set to be yes/no so it had been given a
default value of 0 - even though I changed it to a custom date format, the
damage was done. If only there was an easy way to get rid of all those 0's.