<p>Hi people of great minds!<br>
<br>
I would like to ask for your help, please...<br>
<br>
In my project "open" script, I've declared 2 variables (StartDate, EndDate):<br>
<br>
//
<br>
<br>
var sqlText = new String();<br><br>
sqlText =<br><br>
DECLARE
@StartDate as DATETIME<br>
DECLARE
@EndDate as DATETIME<br><br>
SET
@StartDate = DATEADD(month, DATEDIFF(month, 0, getdate()), 0)<br>
SET
@EndDate = convert(datetime,convert(varchar(10),(getdate()-1),120) + ' 23:59:59')<br>
<br>
< select ><br>
< from ><br>
where<br>
workorder.actfinish >=
@StartDate<br>
and workorder.actfinish <=
@EndDate<br>
<br>
<br>
maximoDataSet.setQuery(sqlText);<br>
<br>
//
<br>
<br>
Now, how do I fetch the values of StartDate and EndDate for them to get displayed in my report?<br>
I've read through few forums and articles and most of those suggest declaring a global variable, but "Variables" is not available in my hierarchy:</p>
<p> </p>
<p>
