Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add years to field in dynamic action

FC60Feb 16 2017 — edited Feb 17 2017

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.

This post has been answered by Pavel_p on Feb 17 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2017
Added on Feb 16 2017
7 comments
472 views