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