How do I code the "Timestamp Range" parameter class into the query?

[coltae]

What are the expressions I should use? How do I link the range to the respected variables? Example "Date created" and "Date Finished" need to be the To and From parameters?

 

Thank you for any help!

 

-Colt

[RamaKrishna.B]

hi

can you explain the issue in detail so that i can help you

[zh3ntil]

Jasper Query:                                                                            SQL Query:

where $X{BETWEEN,column_name,param1,param2} -----> where column_name>param1 and column_name<param2

where $X{[bETWEEN,column_name,param1,param2} -----> where column_name>=param1 and column_name<param2

where $X{BETWEEN],column_name,param1,param2} -----> where column_name>param1 and column_name<=param2

where $X{[bETWEEN],column_name,param1,param2} -----> where column_name>=param1 and column_name<=param2