kd11 Posted September 20, 2017 Share Posted September 20, 2017 hello i have been trying to filter date range in my report. i want to display information in a certain date range. is there any guide that can help me. I tried reading up on it but i cannot set the filter / parameter. is there any particular line i need to add to my query. i have a list of dates and now i want to select a certain dates. for example 1/06/2017-25/06/2017. how can i set this up ? thanks Link to comment Share on other sites More sharing options...
kaushiklokesh123 Posted October 4, 2017 Share Posted October 4, 2017 Hi,You need to create 2 parameters....one for start date and other for End Date.Your query will be like 'where date_column between $P{Start Date} and $P{End Date}Hope this will solve your problem statement 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