shawnmberkeley

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.

Outcomes