Date null = 0000-00-00
I want to get rid of displaying 0000-00-00 if date value is left unfilled.
On original add form, it shows fine ie blank textbox, but when I submit, it and then later try to modify it, it shows 0000-00-00 on text box.
How do I get rid of these 0's.
Do I need to add clobal template maybe? Or is it just setting up the values. Currently I have set date box to NULL in MySQL.
Thx
On original add recored the textbox value is set to: value=""
And on modify form is set to: value="<%Birthday%>"
On original add form, it shows fine ie blank textbox, but when I submit, it and then later try to modify it, it shows 0000-00-00 on text box.
How do I get rid of these 0's.
Do I need to add clobal template maybe? Or is it just setting up the values. Currently I have set date box to NULL in MySQL.
Thx
On original add recored the textbox value is set to: value=""
And on modify form is set to: value="<%Birthday%>"
Date null = 0000-00-00