1 of 1 people found this helpful
If you define an indexed calculation field with this expression:
job::DateDelivery_Scheduled - job::DateToVendor_Scheduled ≤ 3
You can perform a find looking for the value 1 (or True) in that field.
If you define the field to be:
job::DateDelivery_Scheduled - job::DateToVendor_Scheduled
You can use:
As your search criteria. The latter option allows for searching for other intervals besides 3 days.
Thanks philmodjunk. That makes sense and seems like it would work.
Out of curiosity, is there a way to script it without defining an additional field?
Yeah, but it aint pretty. You'd have to either use a filtered portal that filters on this criteria or do a looping script that computes the range on each record and omits the record if the range is not what you want in the records of your found set.
Your solution adding a field worked beautifully! Thanks again.