Advanced Tools

Find Records by Day of the Week

Want to know how many orders you took on Monday for a given time period? Or, how many people make payments on Monday? It’s easy! In FrameReady you can do more than just search by day or date range, you can search by the day of the week.

How to Find by Day of the Week

1.  On the Main Menu, in the Work Orders section, click the Find Work Order button.
   
   The Enter Search Criteria screen appears.

2. Locate the Date field, and enter your date range, e.g.  1/1/18...   (for all orders entered after January 1, 2018).
   
   But here is the trick! Enter the three letters of the day of the week in front of that date range, e.g.  Mon 1/1/12...   

3. Click the Perform Find button.

One of three things will happen:

1. All of the Work Orders taken on that day appears in List View.

2. One Work Order appears in Form View.

3. There may be no records found which means no Work Orders were taken on that day of the week during the specified time period.

How to find Payments by Day of the Week

You can use this same format on the Invoice screen to see how many payments are made on that day of the week.

1. In the Invoice file, click on Find.

2. Enter the date range in the Date field.

3. Enter the day of the week in the Payment Lines Date field (lower left corner).

4. Click the Perform Find button.
   
   All Invoices created in your date range (e.g. after Jan. 1st, 2018) and with a payment made on the weekday you specified (e.g. Monday) are found.

 

© 2019 Adatasol Inc. Makers of FrameReady www.adatasol.com www.frameready.com