iif(year(进校日期)=year(Date()) And 进校日期 <= Cdate(cstr(year(Date)) +'-09-01', 0, IIF(进校日期 Is Not Null,int(datediff('d',IIF(进校日期 > Cdate(cstr(year(进校日期)) +'-09-01'),Cdate(cstr(year(进校日期)) +'-09-01'),Cdate(cstr(year(进校日期)-1) +'-09-01')),Date())/365.2422))) As 工龄
加好友 
发短信
Post By：2019/4/16 14:55:00 [显示全部帖子]
