0

Logic/Triggers

How can I express these calculations:

If  Yes/No Field 1 = Yes, then Date Field 4 = 5 years from Date Field 2

If Yes/No Field 1 = No, then Date Field 5 = 6 years from Date Field 3

1 reply

null
    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view

    if yes = 1 then 'date field 4' := 'date field 2' + 5*1000*60*60*24*365

    else 'date field 5' := 'date field 3' + 6*1000*60*60*24*365

    (you need to add milliseconds 

Content aside

  • 6 yrs agoLast active
  • 1Replies
  • 1971Views