dataset queryText

Arlene

Hi i new here..i really need your help...
i want to create a query in dataset beforeOpen method that contains BIRT function.
For example like this :

var df = new Packages.java.text.SimpleDateFormat("yyyyMMdd");
var now = new Date();
var holiDate = df.parse(row["holiDate"]);

this.queryText = "SELECT * FROM holiday WHERE holiDays = " + BirtDateTime.weekDay(expDate, 1);

It is possible to do above script??


thanks
Arlene