一个access数据库的日期提醒代码

来源:互联网 发布:教育信息化 大数据 编辑:程序博客网 时间:2024/04/29 19:32
select hy.hy_id as hyid,hy.hy_xm as hyxm,kjb.kjb_mc as hyjb,format(hy.hy_csrq,"mm月dd日") as hycsrq
from hy inner join kjb on hy.hy_kjb=kjb.kjb_id
where (not hy.hy_csrq is null) and ((DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date()),hy.hy_csrq)) BETWEEN 0 AND 15) or (DateDiff('d',Date(),DateAdd('yyyy',DateDiff('yyyy',hy.hy_csrq,Date())+1,hy.hy_csrq)) BETWEEN 0 AND 15)) and hy_zt<>1
原创粉丝点击