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!

Reference sysdate inside JavaScript code

Padmocho-OracleMay 22 2018 — edited May 22 2018

Hi,

I have an OnChange DA expression which uses some  Javascript for the True Action.

On the page I have a kind of counter which reaches 100 when all mandatory fields are completed. At that point I would like to update one of my columns with a date (to mark when the request has been filled-in).

My idea was to add something like below to my True action code:

if (pct > 99) {

    $('#P8_QUALIFICATION_DATE').val(':SYSDATE-100');

    }

However, the :SYSDATE reference here doesn't seem to work. Is there any way I can update the Item with current timestamp from within JS code like that?

Any other ideas how I could implement the idea?

Best regards,

Pawel.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2018
Added on May 22 2018
5 comments
1,256 views