1 Reply Latest reply on May 14, 2014 9:23 AM by philmodjunk

    Generating a Daily report from a set time of day

    george@colorproprint

      Title

      Generating a Daily report from a set time of day

      Post

           I have a "Daily" report button on my Job Order that I would like to use to generate a report of Orders entered from the previous day at 12:30pm to the current day at 12:30pm. Right now all I can get is from 12am on the current day. Any suggestions?

        • 1. Re: Generating a Daily report from a set time of day
          philmodjunk

               You need a timestamp field. Such a field will combine date and time in a single field and then you can use a range or inequality in your search criteria to pull up a found set of the needed records for your report. ( a relationship to do the same is also possible.)

               If you only have separate date and time fields, you can add a calculation field to your table that combines them into a timestamp using this expression:

               TimeStamp ( YourDatefield ; YourTimeField )

               Be sure to select "TimeStamp" as the calculation field's result type.

               Then you can specify such date and time criteria in this field to produce the needed found set of records.