i'm trying to generate a report of entries between two dates....
here date1 and date2 are date-time picker values...
Code:
Select * From Expense where supplier = '" & supp & "' AND Date BETWEEN " & date1 & " AND " & date2
and in the db they are date-time values...
but even if i pass the dates as 1/1/2013 and 1/1/2014 it retrieves nothing.. though there are many entries...