Find by Hour, Day, Year

Day, Date, and Year searches can be made in any Date field in FrameReady.

Find Work Orders or Sales by Hour, Day, and Year

  • Do you want to know how many orders you took before 10 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 search by the day of the week, hour of the day, or by year.

Tip: Day, Date, and Year searches can be made in any Date field in FrameReady. A search by Time can only be made in the Creation Time field in the Work Order file.

How to Find by Day of Week

  1. On the Main Menu, click Find Work Order or Find Invoice.

  2. In the Date field, enter the three letters of the day of the week,  e.g.  Mon  ,  then enter your date range, e.g.  11/2022  to find all orders created on a Monday during the month of October 2018.

    Your search criteria looks like this:  Mon 11/2022 

Tip: If the date range is an entire month, you can use the  *  character, e.g.  10/*  to find all records for October (of this year) or  10/*/2022 (for a past year).

  1. Click the Perform Find button.

    A list appears if there is more than one record found. If there is only one record, the screen switches to form view. If no records match your request, a message appears to inform you.

  2. If more than one Work Order is listed, then look in the top left corner to see how many Work Orders were found. This gives you the number of records matching your search criteria.

How to Find by Hour of Day

  1. On the Main Menu, click Find Work Order or Find Invoice.

  2. In the Creation Time field, enter the hours of your search using 24 hour clock notation, e.g. 6 PM is entered as  18:00  .

  3. Click the Perform Find button.

    A list appears if there is more than one record found. If there is only one record, the screen switches to form view. If no records match your request, a message informs you.

How to Find by Year

  1. On the Main Menu, click Find Work Order or Find Invoice.

  2. In the Date field, enter the year, e.g.  2019 .

    When you leave the field, FrameReady converts it to the format */*/2019 to search for all possible dates during that year.

  3. Click the Perform Find button.

    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

Tip: 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 Find.

  2. In the Date field, enter the date range.

  3. In the Payment Lines Date field (lower left corner of the screen), enter the day of the week, e.g.  Mon 

  4. Click the Perform Find button.

    A list appears of all Invoices created in your date range with a payment made on the day of the week you specified.

 

© 2023 Adatasol, Inc.