"Data type mismatch in criteria expression"

Vote count:

0

I have tried to select all records from a table from date1 to date2, Example Jun 28, 2014 to Jan 05, 2015, for display. Basically, sort out selected records based on date criteria. Big thanks if anyone could point out my mistake.

What I tried to do here is allowed user to select specific dates from calendar to view the records

I have gone through all answers, but still couldn't find similar solution to mine. I think, there may be some error in my syntax.

sqlDateRangeSearch = "Select * from BatteryDataTable where ((BatteryDateChanged) <= """ & Me.FromDTPicker.Value & """)" & " and ((BatteryDateChanged) <= " & """" & Me.ToDTPicker.Value & """));"

Me.RecordSource = sqlDateRangeSearch

asked 31 secs ago

AccessUser

1

"Data type mismatch in criteria expression"