gerramirez Posted July 6, 2018 Share Posted July 6, 2018 Ho to make $X{[bETWEEN] with parameter of type date rangeAND $X{EQUAL, "FRRM"."AVNUMAP", AVION_SERIE} AND $X{BETWEEN, DATE, FECHA_INICIAL, FECHA_FINAL}thats righ? Link to comment Share on other sites More sharing options...
reportdev Posted July 6, 2018 Share Posted July 6, 2018 http://jasperreports.sourceforge.net/sample.reference/query/index.html#clause_functionscheck that community page. you will get more info from that page Link to comment Share on other sites More sharing options...
joseng62 Posted July 12, 2018 Share Posted July 12, 2018 Not sure how well that is going to work with dates, you might need to format the date first. Why not just used the normal between sql function for dates to achieve what you want ? WHERE ((yourdatefield BETWEEN TO_DATE(yourstartdate, theformatofthedate ) AND TO_DATE( yourendate, theformatofthedate ) ) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now