Sorry if this is a super easy question but i am trying to figure out a way to get a perform a find based on certain criteria.
I have 2 fields named "Contracts::ContractDate" and "Contracts::CancellationDate"
What im am trying to do is this. I have a button setup to performa script that will perform a find request to find all records that have a cacellationdate that is more than 3 days past the contract date.
I have this below but it wont seem to work properly. Please help, any input is appreciated. Thank you!
Got to Layout ["New Contract Edit" (Contracts)]
Enter Find Mode [ ]
Set Variable [$ContrDatePlus4; Value: Contracts::ContractDate + 4]
Set Field [Contracts::CancellationDate; " > " & $ContDatePlus4]
Perform Find [ ]
I've tried other similar variations but i cant get it to work. Thanks again!