>Thanx for your answer but problem arises when I entered the date
>01/08/2000 i.e. 1st Aug.2000 & computer takes it as 08/01/2000 i.e.
>8th Jan 2000 in that case how should i do comparision.
>For your refernce i have tried filterisation fo date also.
>I have tried variables type like string, Date but it also dosen't
>work. Pls. send me ans if you have any idea . . .

When comparing dates, VB always begin by checking if the date can be mm/dd/yy. If so it takes it and this is your case.

To avoid this, you should always give date with a format of yyyy/mm/dd. With this format, there is no possible mismatch. You can force this format using format(date, "yyyy/mm/dd").