Skip to Main Content

Oracle Forms

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!

How To Set Item Initial Value To Tomorrow

littlecatJan 16 2026

I wish to set item initial value to tomorrow.

I know can use $$DBDATE$$ for sysdate, but will not allow $$DBDATE$$ + 1

I am presently using when-new-record-instance trigger at block level with trunc(sysdate) + 1

Problem with this is that it causes date_lov.get_date to not work. This previously discussed years ago in date calendar problem - Oracle Forums and not solution provided.

date_lov is the Oracle provided calendar from years ago that works with Calendar90 library.

when-new-record-instance and date_lov.get_date appear to not play together nicely.

Comments
Post Details
Added on Jan 16 2026
1 comment
86 views