Finding Orders or Sales by Hour, Day, Year

Want to know how many orders you took before 10:00 am on a Monday for a given time period? Or, how many people make payments on a specific day of the week? It’s easy!

In FrameReady, you can do more than just search by a date or date range, you can also search by the day of the week, hour of the day, or by year. These Day, Date, and Year searches can be made in any Date field in FrameReady. Note that a search by Time can only be made in the Creation Time field in the Work Order file.

How to do a Find by Day of Week

  1. On the Main Menu, click the Find Work Order button.
  2. In the Date field, enter the three letters of the day name of the week,  e.g. Mon then a space, then enter your date range, e.g. 10/1/2022…10/31/2022 to find all orders created on a Monday during the month of October 2022, like so: Mon 10/1/2022…10/31/2022.
  3. Click Perform Find.
  4. If more than one record is found, a list appears. If there is only one Work Order, then it is displayed. If no records match your request, then a message lets you know.

When more than one Work Order is listed, look in the top left corner to see how many orders were found. This will give you the number of records matching your search criteria.
Find the number of work order

How to do a Find by Hour of Day

  1. On the Main Menu, click the Find Work Order button.
  2. In the Creation Time field, enter the hours of your search, using the 24 hour clock, e.g. 6 pm is entered as 18:00.
  3. Click the Perform Find button.
  4. If more than one record is found, a list appears. If there is only one Work Order, then it is displayed. If no records match your request, then a message lets you know.

Wo -creation time

How to do a Find by Year

  1. On the Main Menu, click the Find Work Order button.
  2. In the Date field, enter the year, e.g. 2022. When you leave the field, FrameReady will convert it to the format */*/2022 to search for all possible dates during that year.
  3. Click the Perform Find.button.
  4. A list appears; look in the top left corner to see the number of records in your Found Set.

How to Find Payments made on a day of the week

You can use the same search format in Invoice to see how many payments were made on a specific day of the week.

  1. In the Invoice file, click Find.
  2. Enter the date range in the Date field.
    IN date range
  3. Enter the day name of the week in the Payment Lines Date field in the lower left corner of the screen.
    IN- Payment lines
  4. Click the Perform Find button.
  5. A list appears of invoices created in your date range, e.g. after January 1st, 2022) and had a payment made on the specified day of the week, e.g. Monday.