How to script a find for records with a range between two calculated date fields?

Discussion created by shawnmberkeley on Mar 24, 2017
Latest reply on Mar 24, 2017 by shawnmberkeley

I am attempting to write a script to find only records that have three days or fewer between two calculated date fields.


job::DateDelivery_Scheduled - job::DateToVendor_Scheduled ≤ 3


It might not matter for the find script, but the date fields are calculated as follows:


Case (

not IsEmpty (DateDelivery_Revised ) ; DateDelivery_Revised ;

DateDelivery_Original )


Case (

not IsEmpty (DateToVendor_Revised ) ; DateToVendor_Revised ;

DateToVendor_Original )


I just cannot seem to make the find work.  Any help would be appreciated.