Between a period of time

hi friends

Code: ( text )

set rsschedcheck = Server.CreateObject("ADODB.Recordset")
sqlschedcheck = "SELECT ACPADMIN.Tbl_RequestInfo.ReqServicetypeid, ACPADMIN.Tbl_RequestInfo.ReqArea, ACPADMIN.Tbl_RequestInfo.ReqCraft, " &_
"ACPADMIN.Tbl_RequestInfo.ReqGroup, ACPADMIN.Tbl_RequestInfo.ReqRschedDate, ACPADMIN.Tbl_RequestSched.RschedTime, ACPADMIN.Tbl_RequestInfo.ReqStatus " &_
"FROM ACPADMIN.Tbl_RequestInfo INNER JOIN ACPADMIN.Tbl_RequestSched ON ACPADMIN.Tbl_RequestInfo.ReqID = ACPADMIN.Tbl_RequestSched.RschedReqid " &_
"WHERE (((ACPADMIN.Tbl_RequestInfo.ReqServicetypeid)=" & ReplaceQuote(textservicetype) & ") AND ((ACPADMIN.Tbl_RequestInfo.ReqArea)=" & STR_Quote2(ReplaceQuote(textservicearea)) & ") " &_
"AND ((ACPADMIN.Tbl_RequestInfo.ReqCraft)=" & STR_Quote2(ReplaceQuote(textcraft)) & ") AND ((ACPADMIN.Tbl_RequestInfo.ReqGroup)=" & STR_Quote2(ReplaceQuote(textgroup)) & ") " &_
"AND ((ACPADMIN.Tbl_RequestInfo.ReqRschedDate)=" & (DateDelimiter(FormatDateTime(textsched,2))) & ") " &_
"AND ((ACPADMIN.Tbl_RequestSched.RschedTime)BETWEEN " & DateDelimiter(FormatDateTime(schedSTime,4)) & "AND" & DateDelimiter(FormatDateTime(schedETime,4)) & ") " &_
"AND ((ACPADMIN.Tbl_RequestInfo.ReqStatus)<>'Cancelled') AND ((ACPADMIN.Tbl_RequestSched.RschedStatus)<>'Cancelled')) " &_
"ORDER BY Tbl_RequestSched.RschedTime"

in browser the values is showing as

Code: ( text )

SELECT ACPADMIN.Tbl_RequestInfo.ReqServicetypeid, ACPADMIN.Tbl_RequestInfo.ReqArea, ACPADMIN.Tbl_RequestInfo.ReqCraft, ACPADMIN.Tbl_RequestInfo.ReqGroup, ACPADMIN.Tbl_RequestInfo.ReqRschedDate, ACPADMIN.Tbl_RequestSched.RschedTime, ACPADMIN.Tbl_RequestInfo.ReqStatus FROM ACPADMIN.Tbl_RequestInfo INNER JOIN ACPADMIN.Tbl_RequestSched ON ACPADMIN.Tbl_RequestInfo.ReqID = ACPADMIN.Tbl_RequestSched.RschedReqid WHERE (((ACPADMIN.Tbl_RequestInfo.ReqServicetypeid)=1) AND ((ACPADMIN.Tbl_RequestInfo.ReqArea)='6RD-6RA-6RB') AND ((ACPADMIN.Tbl_RequestInfo.ReqCraft)='EL') AND ((ACPADMIN.Tbl_RequestInfo.ReqGroup)='1') AND ((ACPADMIN.Tbl_RequestInfo.ReqRschedDate)='3/29/2008') AND ((ACPADMIN.Tbl_RequestSched.RschedTime)BETWEEN '14:30'AND'15:14') AND ((ACPADMIN.Tbl_RequestInfo.ReqStatus)<>'Cancelled') AND ((ACPADMIN.Tbl_RequestSched.RschedStatus)<>'Cancelled')) ORDER BY Tbl_RequestSched.RschedTime

and its showing the error as not a valid month
can any one help me in this situastion