The value of my dates in my database is ="MMDDYYYY"
I insert it using this code:

Code:
replace(convert(varchar(10), date, 101), '/', '')
it returns like this output

06072018

And now I don't know how select this kind of output using datepicker?

Code:
rs1.Open "SELECT * FROM tbl_hourlysalesdetails WHERE Date='" & Format(DTPicker1.Value, "MMddyyyy") & "' and posno='" & Combo1.Text & "' ", cn, 1, 3
on debug mode the format is still mm/dd/yyyy ...
because i want to check on my database if that date is existing..

please help me