Something about DATE 1

[gerry03]

Hi
How can i save blanks in DATE/TIME type field of an access table and how can i retrv. the same with sql. I am using ADO. Secondly datepicker doesn't give the desired output.
for exmpl. if i click it doesn't diaplay the formated date in text boexs.


Thanks

 

[CCLINT]

1. Save a NULL to the Date field:
...SET DateField = NULL

2. Use NULL in your criteria:
...WHERE DateField IS NULL
or
...WHERE NOT DateField IS NULL

3. Use the Format$() function:
Text1.Text = Format$(myDatePicker,"mm/dd/yyyy&quot