Using function inside of $X()

[dan_14]

Does anyone know how to use a function inside of the $X() method?

I need to convert a date when including in my where clause:

 

$X{BETWEEN, CONVERT_TZ(FROM_UNIXTIME(a.date / 1000),'UTC',TimeZone),StartDate,EndDate}

 

Note - TimeZone, StartDate, and EndDate are all parameters. I even setup UTC as a string parameter but still getting an error.

[ernestoo]

You'll just have to manually write the SQL, something like:

WHERE CONVERT_TZ(FROM_UNIXTIME(a.date / 1000),'UTC',TimeZone) BETWEEN $P{StartDate} AND $P{EndDate}[/code]