I have problem of selecting recordset between a specified date. I am giving my coding detail below.
I took a field in Ms Access table
fieldname - doj
datatyoe - Text
dim db as new adodb.connection
dim rc as new adodb.recordset
db.open"Provider=Microsoft.Jet.OLEDB.4.0; Data Source='d:\tmgmt.mdb'"
rc.open"select * from travel where braise='NO' AND Doj between #"& doj.value &"# AND #"& doj.value &"# order by doj desc;",db, adOpenDynamic, adLockBatchOptimistic
but it will not give recordset between above specified date or within date range.
i set the date format from control panel dd/mm/yyyy but not work. Please help