AnsweredAssumed Answered

Calculate Date

Question asked by bvanni on Apr 25, 2017
Latest reply on Apr 27, 2017 by bvanni

Hi All,


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!