var _sql="SELECT ITEM_截止日期,domainid FROM TLK_员工档案";
var docs=queryBySQL(_sql);
var values;
for (var iter = docs.iterator(); iter.hasNext();) {
var doc = iter.next();
values += doc.getItemValueAsDate("截止日期");
}
往后怎么写
具体实现脚本如下:
var currentDay=getToday();
var newDay=adjustDay(currentDay,10);
var endDay=format(newDay,"yyyy-MM-dd");
println(endDay);
"SELECT * FROM TLK_员工档案 where ITEM_截止日期<'"+endDay+"'";