24 hour Report

[birchtree]

Hello, I truely appreciate this fabulous forum!

I have a Work Order System and I want to perform a find on for Orders that have come in the last 24 hours. I don't want todays orders or yesterdays. It has to be the last 24 hours. Is that possible?

Thanks very much

Birchtree

[Ocean West]

I recommend to use oAzium Date & Time Plugin....

This will create a range of dates/times that represent your 24 hrs and then you can use a script to goto relate records....

[Thom]

You need to combine your date and time fields so that you can search for records with a date and time greater than yesterday at this time.

dateAndTime(calc,text) =

Right("0000000" & dateField,7) & Right("00000" & timeField,5)

Write a script like this:

Enter Find Mode []

Set Field [ dateAndTime,