This is Run Accurately and Display Accurate Rcords in Grid
In Table Date Field is as: 25/02/08,25/03/08
Date Format : dd/mm/yy (Short Date)
“SELECT Name, BookingDate From Passenger WHERE BookingDate Between #2/25/2008# And Date()”
But This is Not Run.
“SELECT Name, BookingDate From Passenger WHERE BookingDate Between #” & CDate(DTPicker1) & “# And Date()”
This Query Display only one empty record in Grid.
No Error
No Result
Why ?
Please Help Me.
