Hi All,<BR>I am written this query for retirving the data. database in access and the date format is mm/dd/yy.<BR>i want to check the record from getStartWeekDay="06/25/01" and Date(). but i am getting the resulet the 06/20/01. i don&#039;t know what is going wrong.<BR><BR>set rsShow = objCon.Execute("select * from mesg where Date1 between "&getStartWeekDay&" and Date() order by date1")<BR><BR>Affan