Format Date Parameter In jxls

[Andra VP]

Hi,
I want to format date parameter to YYYY-MM-DD Can you help me to format date from date parameter (date1.sqlValue and date2.sqlValue)?
Here is my script:

jx:each(items="jdbc.query('select * from orders where to_char(due_date, 'yyyy-mm-dd') between ? And ?', date1.sqlValue,date2.sqlValue)" var="item" lastCell="B3")

[Timothy Anyona]

What database are you using?

[Andra VP]

I use postgresql

[Timothy Anyona]

1. What is the data type of the due_date column?
2. What is the data type of the date1 and date2 parameters?

[Andra VP]

Here is:
1. due date = timestamp
2. date1 and date2 = Date

[Timothy Anyona]

What version of ART are you using?

[Andra VP]

I use ART 5.16

[Timothy Anyona]

What if you try

jx:each(items="jdbc.query('select * from orders where due_date between '+date1.sqlValue+' AND '+date2.sqlValue)" var="item" lastCell="B3")