Using SQL user-defined functions in $X{}

[vinayt]

Am new to JasperReports. As part of creating a query in report, am facing an issue.

I have a sql query similar to below one : am trying to convert a date value to different date using a user defined SQL Function.

Select * from Person where (CreatedDate < dbo.ConvertLocalDateToUTC($P{dsRegistration_attemptEndDt_pDate_MinRange} + ' 00:00:00',$P{UserTimeZoneFK}))[/code]

How can i write the same Where clause in JasperReports using $X{} as the where clause contains a user defined function?

I tried to write as below, but it is not working.

Select * from Person where $X{LESS, CreatedDate, dbo.ConvertLocalDateToUTC($P{dsRegistration_attemptEndDt_pDte_MinRange} + ' 00:00:00',$P{UserTimeZoneFK}) }[/code]

Can any one please let me know, how can i use the Sql user-defined functions in sql queries ofJasperReports. Am working on this from 2 days, but still i couldn't get anything.