1 (edited by manixs2013 2019-10-28 09:50:38)

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!

Re: DATE

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.

Re: DATE

Hello MVD and TCOTON!


I got a solution..


          FORM1.cDateIssued.DateTime := (nil);
          FORM1.cDateIssued.Checked := false;


Thanks!