I have to find out report between two dates. (I am using VB 6 language and MS Access as Database). My following query executes fine if date format is d/M/yyyy in Control Panel.
Dim s as string
s = "select * from customer where dat between #" & DTPicker1.Value & "# and #" & DTPicker2.Value & "# "
Rec.Open s, Con, 1, 3
But when I changed the format from d/M/yyyy to d/M/yyyy. My above query executes but it does not show correct result.
Plz Plz tell me solutiuon. I will be very thankful to you.