请帮忙看一下这段ASP代码，关于日期比较的问题！

来源：百度知道编辑：UC知道时间：2024/05/17 02:30:38

Dim rs__MM_C_Date_S
MM_C_Date_S = "1"
If (Request.Form("C_Date_S") <> "") Then
MM_C_Date_S = Month(Date)/Request.Form("C_Date_S")/Year(Date)
End If

Dim MM_C_Date_O
MM_C_Date_O = "1"
If (Request.Form("C_Date_O") <> "") Then
MM_C_Date_O = Month(Date)/Request.Form("C_Date_O")/Year(Date)
End If

SQL查询如下

SELECT * FROM Now_Mon WHERE C_Date >= '" + Replace(MM_C_Date_S, "'", "''") + "' And C_Date <= '" + Replace(MM_C_Date_O, "'", "''") + "'"

C_Date是日期类型格式为 MM/DD/YYYY

功能要求是表单传递一个日期段，然后从数据中找出符合这个日期段的所有数据

我不知道哪里写错了，也试了另外的几种写法，可总是提示我说“表达式中的数据类型不匹配”
SELECT * FROM Now_Mon WHERE C_Date >= ＃" + Replace(MM_C_Date_S, "'", "''") + "＃ A

用between或者用datediff
between用法
sql = "SELECT * FROM Now_Mon WHERE C_Date between #" & MM_C_Date_S & "' And #" & MM_C_Date_O & "#"
或者datediff用法
sql = "SELECT * FROM Now_Mon WHERE datediff('s',C_Date," & MM_C_Date_S & ")>0 And datediff('s'," & MM_C_Date_O & ",C_Date)"

SELECT * FROM Now_Mon WHERE C_Date >= '" + Replace(MM_C_Date_S, "'", "''") + "' And C_Date <= '" + Replace(MM_C_Date_O, "'", "''") + "'"
把查询语句用下面这句试试；
SELECT * FROM Now_Mon WHERE C_Date >= ＃" + Replace(MM_C_Date_S, "'", "''") + "＃ And C_Date <= ＃" + Replace(MM_C_Date_O, "'", "''") + "＃"

请ASP高手帮忙看段代码 asp高手帮忙看一下这段代码帮忙看一下这段代码ASP什么意思? 请帮忙看一下这段ASP代码，关于日期比较的问题！请帮忙看看这段asp代码请高手帮忙看一下这段代码。。统计问题帮忙看一下这段HTML代码帮忙看一下这段代码帮忙看一下这段检验代码哪里错了?ASP 大家帮忙看一下这段代码?ASP转HTML的.