Check Dates 

 [ You Pick Reservation ]  [ Quick Pick Reservation ] [Reservation System]

Site Number " size="08">
Start Date " size="08" maxlength="8">
End Date " size="08" maxlength="8">
                              &StartDate=<%=Request("StartDate")%>&EndDate=<%=Request("EndDate")%>">
<% fp_sQry="SELECT SiteNumber, StartDate, EndDate FROM SiteCalendar WHERE (SiteNumber = '::SiteNumber::' AND (StartDate = '::StartDate::' OR StartDate between '::StartDate::' and '::EndDate::' OR EndDate between '::StartDate::' and '::EndDate::' OR EndDate = '::EndDate::' OR '::StartDate::' between StartDate and EndDate OR '::EndDate::' between StartDate and EndDate ))" fp_sDefault="SiteNumber=&StartDate=&StartDate=&EndDate=&StartDate=&EndDate=&EndDate=&StartDate=&EndDate=" fp_sNoRecords="" fp_sDataConn="reserve" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=5 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="SiteNumber" fp_sMenuValue="SiteNumber" fp_iDisplayCols=3 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %>
Site Number Start  Date End Date  
This site has no reservations for the above dates
<%=FP_FieldVal(fp_rs,"SiteNumber")%> <%=FP_FieldVal(fp_rs,"StartDate")%> <%=FP_FieldVal(fp_rs,"EndDate")%> Site is reserved on these dates.