关于分时间段查询的问题?
sDate = Request.QueryString("TimYear") & "/" & Request.QueryString("TimMonth") & "/" & Request.QueryString("TimDay")
这个我要往后边继续加上东西怎么加。比如要加上TimYear1......TimMonth1.....TIMDay1
If Request.QueryString("StoreCd") <> "" Then
sWhere = sWhere & " AND a.StoreCd = '" & ToSQL(Request.QueryString("StoreCd")) & "' "
End If
If Request.QueryString("TimYear") <> "" And Request.QueryString("TimMonth") <> "" And Request.QueryString("TimDay") <> "" Then
sWhere = sWhere & " AND a.WorkDate='" & Request.QueryString("TimYear") & "/" & Request.QueryString("TimMonth") & "/" & Request.QueryString("TimDay") & "' "
End If
这个是第一个数据的判断,然后第二个数据的判断要怎么写。。还是TimYear1......TimMonth1.....TIMDay1要怎么加上去。。。 WorkDate为数据库里存的日期是2005-12-1的形式。