&nbsp;<BR>i would like to search through my db to get all entries that were entered within the last week only.<BR>i am using this statement but it is returning entries that are outside of this range, am using access and vbscript.<BR>any ideas?<BR>thanks<BR><BR> sqlstatement1 = " select * from hours_available where dat &#062; DateAdd(""w"", -1 , date()) and shift like &#039;%1%&#039; and dai like &#039;%sunday%&#039; "<BR>