Using BAQ, How do I set up a query that can display only records within certain dates range?
This is pretty trivial in BAQ , checkout the User Experience and Customization Manual and the ICE Manual
2 Likes
You will need to add a table criteria to your query for the date range. Do you need screen details? Usually you select the table in the query designer and then add a criteria/filter to the table for the column you want to test.
Josh
Josh,
Yes please, I need screen details. and thanks
Felix
Here is a few screen shots. This is a short query to pull receipt headers and details lines between a start and end date. This has input parameters built into the BAQ. I created the parameter StartDate and EndDate. The BAQ request these at execution time.
Start a new BAQ. Add the table(s) you want in the query. Add Table Criteria to whichever table you need to. Set the filter value to be X parameter name. Then, select the fields to be part of the query. Test to the query for results.
This is a test database from May 25 so this is why my dates are so far back.
Click OK and this is the results
If you need further assistance private message me.
Josh
1 Like
Please keep the interaction in the forum so that everyone can benefit
1 Like
@josecgomez will be delighted too. Still getting used to this forum and thought a bunch of emails with small questions may aggravate some. I have noted this response. If I am contacted I will get further detail and post whatever is discussed. Thanks for the response!
1 Like