/
Select Items for Payment - Date Range Query
Select Items for Payment - Date Range Query
Issue/Symptom/Question
Is it possible to query back records within a window using a date range?
Applies To
PENTA for Windows
Expert Query
Resolution/Fix/Answer
Yes, in many windows we offer a 'Expert Query' function which allows you to query using a variety of different methods, including a 'Between' range for date ranges.
Expert Query how to:
- Place your cursor in the field you are interested in using an expert query
- Click on the Expert Query button on the PENTA toolbar
- NOTE: If you do not see the Expert Query button on the toolbar, the window likely does not support this feature
- Click on the Expert Query function you would like to use, in the below example, we will be using the Between function
- Enter your Expert Query criteria
- Click Apply to apply the Expert Query
- Click Okay to close out of the Expert Query popup
- Finalize the query by click the Enter Query button on the toolbar. PENTA will return all records that match your expert query criteria.
, multiple selections available,
Related content
Validation Error while trying to run the Work Order Query Builder in Work Order Data Export
Validation Error while trying to run the Work Order Query Builder in Work Order Data Export
More like this
SM: Unbilled Work Order Cost panel does not allow me to select a Date Range
SM: Unbilled Work Order Cost panel does not allow me to select a Date Range
More like this
Labor & Overhead Distribution Report Categorized by Date
Labor & Overhead Distribution Report Categorized by Date
More like this
Back Dating AR Invoices
Back Dating AR Invoices
More like this
Standard Crystal Report - Job Revenue And Cost – Month End Summary
Standard Crystal Report - Job Revenue And Cost – Month End Summary
More like this
Limit AR Invoices appearing on Aging Reports
Limit AR Invoices appearing on Aging Reports
More like this