-
Dear All,
I have questions about SQL Statements.
Does anybody know about opening database with date variable as its criteria ???
Let's say that I need to open UNDKT table. And the record that will be showed is the record which is input today.
My SQL Statements :
"Select * from UNDKT where input_date = " & DateValue(TglInput) & ""
Is it true ??? Or you guys have something in mind ????
Need Help ASAP...
BRgds,
Wen Lie
-
It should be like this.
Code:
"SELECT * FROM UNDKT WHERE input_date =#" & DateValue(TglInput) & "#;"
