ASP日期求教

[jackyrong]

输入开始年份和月份，和结束年份和月份，用ACCESS格式，
YYYY-MM格式，要查找符合在这区间的记录，应该如何操作呢？

[jackyrong]

我知道呀，比如：在查询页上设置两个文本筐（记为y1,y2,可以让
用户填入年份），设置两个下拉列表筐（m1,m1，用来选择月份）
那么在处理页中，用Request分别读入这四个变量后，
好象用BETWEEN查不出来，各位能否详细讲下？

[karma]

make the day part of the first date to be 1, make the day part of the second date to be 31 or 30 (or add 1 to the month part and make the day part 1), and use "between". So for example, if your inputs are "2000-01" and "2000-07", you
do
between #2000-01-01# and #2000-07-31#
or
between #2000-01-01# and #2000-08-01#

[comcom]

between #2000-01-01# and #2000-08-01#