ASP.NET Forum

**mhallin** · 03-10-2005, 03:07 AM

I have a calender that filters the recordset with the following command:
<% rsEventsDay.Filter = "EVE_DATED = #" & CurrentDay & "#" %>

EVE_DATED is the Event date in this calendar and i would like the calendar to show recorsets if they are inbetween 2 dates so i added the EVE_DATED2 and treat the EVE_DATED as the start date and the other as the end date of the event.

now i tried this command
<% rsEventsDay.Filter = "EVE_DATED > #" & CurrentDay & "#" AND rsEventsDay.Filter = "EVE_DATED2 < #" & CurrentDay & "#" %>
BUT it does not work!

I never used .Filter before previosly i used the WHERE sql statement. But the calendar i found was coded like this and this must be the easiest way to do it if anyone could give me an idea how to proceed.

I sourced the FAQ forum where i downloaded this calendar and no one have so far helped me out on this.

**Anacrusis** · 03-10-2005, 09:35 AM

Try this:

Code:

<% 
rsEventsDay.Filter = "EVE_DATED > #" & CurrentDay & "#"  & _
        " AND EVE_DATED2 < #" & CurrentDay & "#" 
%>

**mhallin** · 03-10-2005, 06:16 PM

Thank you it worked perfectly!!!

**Anacrusis** · 03-10-2005, 09:33 PM

My pleasure