Parameter Validation Script Error

Pujan

Hello,<br />
<br />
I want to compare the 2 dates (start and end date). I added the following code in the "Validate" script of the End Date. <br />
<br />
<br />
df = new Packages.java.text.SimpleDateFormat("yyyy-MM-dd");<br />
df2 = new Packages.java.text.SimpleDateFormat("yyyy-MM-dd");<br />
myStartDate = df.parse(params["FromDate"].value);<br />
myEndDate = df2.parse(params["ToDate"].value);<br />
if (BirtComp.lessOrEqual(myStartDate, myEndDate)){<br />
true;<br />
}<br />
else{<br />
false;<br />
}<br />
<br />
During Preview I am getting the following error. <br />
<br />
<strong class='bbc'>org.eclipse.birt.report.service.api.ReportServiceException: Parameter "ToDate" script source validation error.</strong><br />
<br />
Can anyone please help me resolve this issue ASAP.

bhanley

What are the values you are supplying for start and end date?<br />
<br />
I would look at using the Date object in your JavaScript rather than SimpleDateFormat. BIRT provides a lot of means to deal with parsing dates out of the box, but those options are generally geared toward using a Date object. (You can check out the DateTimeSpan object for starters)<br />
<br />
The constructor for the Date object can accept a String. Try this script:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>Date dStart = new Date(params["FromDate"].value);
Date dEnd = new Date(params["ToDate"].value);

var date1Comp = dStart.getTime(); // milliseconds
var date2Comp = dEnd.getTime();

if (date1Comp < date2Comp) {
true;
}
else{
false;
}</pre>
<br />
Sending the dates to milliseconds is a fool-proof way to make sure you are doing a fast, accurate evaluation.