首先取当前时间data1,月,还有日,星期,然后通过判断得到本月的起始日期date2,本星期的起始日期date3,然后
本月任务
select * from table where plan_start>data2 and plan_end<data1
本周计划
select * from table where plan_start>data3 and plan_end<data1
首先取当前时间data1,月,还有日,星期,然后通过判断得到本月的起始日期date2,本星期的起始日期date3,然后
本月任务
select * from table where date<data1 and date>data2
本周计划
select * from table where date<data1 and date>data3
sql="select * from table where plan_start>'"&date_year&"/"&date_month&"/"&date_day&" and
plan_end<'"&date_year&"/"&date_month&"/"&date_day&" order by task_id
desc
这是我写的,我就是觉得比较麻烦,想找简单的方法
SQL = "(('"&date_year&"' > Year(plan_start) And '"&date_year&"' < Year(plan_end)) Or ('"&date_year&"' > Year(plan_start) And ('"&date_year&"' = Year(plan_end) And '"&date_month&"'<= Month(plan_end))) Or (('"&date_year&"' = Year(plan_start) And '"&date_month&"' >= Month(plan_start)) And '"&date_year&"' < Year(plan_end)) Or (('"&date_year&"' = Year(plan_start) And '"&date_month&"' >= Month(plan_start)) And ('"&date_year&"' = Year(plan_end) And '"&date_month&"' <= Month(plan_end)))) "
SQL = "Select * "&SQL& " Order By task_id Desc"