<p>Hi All,</p>
<p> </p>
<p>I want my report to run for today's date if date parameter is left blank(for scheduling in maximo). The below logic is working fine in report designer and the report is working when user give the date manually or leave it blank. </p>
<p>The isssue is when I import it in Maximo it gives me error when dates are left blank. Though it runs when i give it date from manually. Not sure what I am missing</p>
<p> </p>
<p>Thanks in Advance !!!!!!</p>
<p> </p>
<p> </p>
<div>var start_date= new Date();</div>
<div>var end_date = new Date();</div>
<div> </div>
<div>if( BirtComp.notEqual(params["p_startdate"], null)) {</div>
<div> </div>
<div>start_date = params["p_startdate"]; </div>
<div>}</div>
<div>else</div>
<div>{</div>
<div>start_date=BirtDateTime.today();</div>
<div> </div>
<div>}</div>
<div> </div>
<div>if( BirtComp.notEqual(params["p_enddate"], null)) {</div>
<div> </div>
<div>end_date = params["p_enddate"]; </div>
<div>}</div>
<div>else</div>
<div>{</div>
<div>//enddate=MXReportSqlFormat.getDateFunction(BirtDateTime.today());</div>
<div>end_date=BirtDateTime.today();</div>
<div>}</div>
<div> </div>
<div> </div>
<div> </div>
<div>sqlText= " SELECT distinct "</div>
<div>+ " case when WORKORDER.istask=0 then WORKORDER.wonum "</div>
<div>+ " else WORKORDER.parent "</div>
<div>+ " end as WONUM,WORKORDER.WORKTYPE,WORKORDER.description wodesc, WORKORDER.status,WORKORDER.OWNERGROUP,0 as hamdblinedt, "</div>
<div>+ " WORKORDER.woeq3, "</div>
<div>+ " labtrans.laborcode,person.displayname displayname_1,labtrans.skilllevel,labtrans.startdate,labtrans.STARTTIME,labtrans.finishdate,labtrans.FINISHTIME,WORKORDER.woeq1, "</div>
<div>+ " round(COALESCE(labtrans.regularhrs,0),2) regularhrs,(select round(sum(COALESCE(downtime,0)),2) AS MCDT From ASSETSTATUS ASSETSTATUS where "</div>
<div>+ " workorder.wonum=assetstatus.wonum and workorder.siteid=assetstatus.siteid and (assetstatus.isrunning=1 or assetstatus.isrunning is NULL ) "</div>
<div>+ " ) MCDT,workorder.assetnum, labtrans.memo "</div>
<div>+ " from LABTRANS "</div>
<div>+ " inner join WORKORDER on workorder.wonum=labtrans.refwo and workorder.siteid=labtrans.siteid "</div>
<div>+ " inner join PERSON on person.personid=labtrans.laborcode "</div>
<div>+ " where ( LABTRANS.startdate >=" + MXReportSqlFormat.getDateFunction(start_date) + " and " </div>
<div>+ " labtrans.startdate<= " + MXReportSqlFormat.getDateFunction(end_date) + ")" </div>
