7 Replies Latest reply on Feb 17, 2017 9:42 AM by Pavel_p

    Add years to field in dynamic action

    FC60

      Hi,

      I need to add 5 years to a second field when I have a value > 500 $ in another filed

       

      1. I create a dynamic action
        1. when - Event:Lose focus; selection type: Item(s); Item: Date1
        2. Client-side condition - Type: Item > Value; Item: Invoice_value > 500
      2. In the branch "True".
        1. Settings - Set type: PL/SQL Expression; PL/SQL Expression date2 :=  add_months(date1,60);

       

      This is my problem: Set type: PL/SQL Expression; PL/SQL Expression date2 :=  add_months(date1,60);

       

      I don't know which is the correct syntax to do this.

       

      Thanks for the help.