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:

1. Place your cursor in the field you are interested in using an expert query
2. Click on the Expert Query button on the PENTA toolbar
   1. NOTE: If you do not see the Expert Query button on the toolbar, the window likely does not support this feature
3. Click on the Expert Query function you would like to use, in the below example, we will be using the Between function
4. Enter your Expert Query criteria
5. Click Apply to apply the Expert Query
6. Click Okay to close out of the Expert Query popup
7. Finalize the query by click the Enter Query button on the toolbar. PENTA will return all records that match your expert query criteria.