I guess there are many ways. But try:

WHERE DTOC(batchdate, 1) <= DTOC(thisform.txtsdate.value, 1)

---

-- SNIP --
>I tried e.g :
> where batchdate <= DTOT(CTOD(DTOC(thisform.txtsdate.value) + ' 23:59')
> but it still does not help.
>Any help?

---

HTH,