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!

Outcomes