Between a period of time

[jestin]

hi friends
[code=asp]set rsschedcheck = Server.CreateOb ject("ADODB.Rec ordset")
sqlschedcheck = "SELECT ACPADMIN.Tbl_Re questInfo.ReqSe rvicetypeid, ACPADMIN.Tbl_Re questInfo.ReqAr ea, ACPADMIN.Tbl_Re questInfo.ReqCr aft, " &_
"ACPADMIN.Tbl_R equestInfo.ReqG roup, ACPADMIN.Tbl_Re questInfo.ReqRs chedDate, ACPADMIN.Tbl_Re questSched.Rsch edTime, ACPADMIN.Tbl_Re questInfo.ReqSt atus " &_
"FROM ACPADMIN.Tbl_Re questInfo INNER JOIN ACPADMIN.Tbl_Re questSched ON ACPADMIN.Tbl_Re questInfo.ReqID = ACPADMIN.Tbl_Re questSched.Rsch edReqid " &_
"WHERE (((ACPADMIN.Tbl _RequestInfo.Re qServicetypeid) =" & ReplaceQuote(te xtservicetype) & ") AND ((ACPADMIN.Tbl_ RequestInfo.Req Area)=" & STR_Quote2(Repl aceQuote(textse rvicearea)) & ") " &_
"AND ((ACPADMIN.Tbl_ RequestInfo.Req Craft)=" & STR_Quote2(Repl aceQuote(textcr aft)) & ") AND ((ACPADMIN.Tbl_ RequestInfo.Req Group)=" & STR_Quote2(Repl aceQuote(textgr oup)) & ") " &_
"AND ((ACPADMIN.Tbl_ RequestInfo.Req RschedDate)=" & (DateDelimiter( FormatDateTime( textsched,2))) & ") " &_
"AND ((ACPADMIN.Tbl_ RequestSched.Rs chedTime)BETWEE N " & DateDelimiter(F ormatDateTime(s chedSTime,4)) & "AND" & DateDelimiter(F ormatDateTime(s chedETime,4)) & ") " &_
"AND ((ACPADMIN.Tbl_ RequestInfo.Req Status)<>'Cance lled') AND ((ACPADMIN.Tbl_ RequestSched.Rs chedStatus)<>'C ancelled')) " &_
"ORDER BY Tbl_RequestSche d.RschedTime"[/code]

in browser the values is showing as

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

[jhardman]

what type of db are you using? some dbs require that dates be designated as #3/29/2008# or '29 Mar 2008'. Your db should have a query analyzer. You can copy this query into the analyzer and see what it gives you. Let me know if this helps.

Jared