how do a show between a certen Dates

ok, ive tryed:

sql = "SELECT * FROM Calls WHERE CallDate > " & DateFrom & " AND CallDate < " & Dateto & " ORDER BY CallDate DESC, CallTime DESC"

but that didnt work, it showed ALL dates

then i tryed:

if rsClient("calldate") > DateFrom AND rsClient("calldate") < DateTo then

but that just wouldnt show anyfin

*crappers i forgot to finish!*

anyway, can anyone find a fault in my coding? or better yet tell me how i do this - thanks for any help (please do help!)

If you're using Access, it needs ## around the date values.

Cheers,
Andrew

BETWEEN!!

Where [FieldName] BETWEEN #Date1# AND #Date2#

Good luck!!

Cheers,
Andrew

ok, its ok, i fixed the from - to in a drop down box...

who know it would work doin
<% for DateLoop = Date()-30 TO Date() %>

 HOW kool is that!

if anyones intressed then you can get a Dropdown box to show from a certen Date to todays Date by using this code
(thought id share wit ya'll)

<SELECT Name="DateFrom">
<% For DateLoop = DateValue("01/01/2003") To Date() %>
<OPTION Value="<%=DateLoop%>"<%if DateLoop = Date()-30 then Response.Write("SELECTED")%>><%=DateLoop%></OPTION>
<% next %>
</SELECT>