Search between two dates

[johnsonk]

Hi, can anyone help, this is my first post regarding Access, I have the code below which works but the only problem is if I put in dates

I get nothing even though there is data on that date.

If I enter dates it works fine

any help would be great.

Dim strCriteria, task As String

Me.Refresh
If IsNull(Me.StartDate) Or IsNull(Me.EndDate) Then
  MsgBox "Please enter a date range", vbInformation, "Date range required"
  Me.StartDate.SetFocus
Else
  strCriteria = "([Date] >=#" & Me.StartDate & " 00:00:00# And [Date] <=#" & Me.EndDate & " 23:59:59#)"
  
  task = "select * from StoresData where (" & strCriteria & ") order by [Date]"
  
  DoCmd.ApplyFilter task
  
End If

 

[jackd]

Try using MM/DD/YYYY format

 

[welshgasman]

Here is something I used when getting dates into required format

Public Const strcJetDate = "\#mm\/dd\/yyyy\#"  'Needed for dates in queries as Access expects USA format.