帆软mysql两个日期之间的天数条件_帆软时间检索限制90天

开始时间

var fdate=new Date(this.options.form.getWidgetByName("FDate").getValue());

var tdate=new Date(this.options.form.getWidgetByName("TDate").getValue());

var times= tdate.getTime() - fdate.getTime();

var days = parseFloat(times / (1000 * 60 * 60 * 24));

if(days<0){

var v=fdate.toLocaleDateString();

v=v.replace(/\D/g,"-");

v=v.replace(/-$/g,"");

this.options.form.getWidgetByName("TDate").setValue(v);

}else if(days>90){

fdate.setDate(fdate.getDate()+90);

var v=fdate.toLocaleDateString();

v=v.replace(/\D/g,"-");

v=v.replace(/-$/g,"");

this.options.form.getWidgetByName("TDate").setValue(v);

}

结束时间

var fdate=new Date(this.options.form.getWidgetByName("FDate"