Topic: DATE
Hello MVD
How to set the date into null or empty? 00/00/0000. I set it to the Form1.Datetextbox.DateTime := 0; but in the form it set to default to 12/30/1899 now, the problem this will display in the report.
Please Help
Thanks!
My Visual Database → General → DATE
Hello MVD
How to set the date into null or empty? 00/00/0000. I set it to the Form1.Datetextbox.DateTime := 0; but in the form it set to default to 12/30/1899 now, the problem this will display in the report.
Please Help
Thanks!
You cannot set a default date to 00/00/0000 because SQL has been designed this way, you better use a N/A or a null as default value and use a case in your request for your report to transform it to the value you want to see.
Hello MVD and TCOTON!
I got a solution..
FORM1.cDateIssued.DateTime := (nil);
FORM1.cDateIssued.Checked := false;
Thanks!
My Visual Database → General → DATE
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi