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!

Days Calculation

Moazam ShareefFeb 16 2009 — edited Feb 18 2009
hi guyz,

I have the four fields in my form as i mention below.
isu_date varchar2(15); database item
exp_date varchar2(15); database item

number_of_days varchar2(15); display item
today_date varchar2(15); display item
isu_date and exp_date are in hijri (i.e. yyyy/mm/dd, 1420/02/15) when i enter date in isu_date is showing the issue date or id and exp_date will show the expiry date, and today_date will display the current system date which is also an hijri

isu_date will disply the issuance of an id date and expiry will display expiry of an id as soon as when user enter the date in exp_date it will count remaning days by below formula in the property of an number_of_days item and it will display the remaing days of an id.
 :block.exp_date - :block.today_date
i did this task before now its giving me errors could some one give me good example of cursor or key-next item trigger on exp_date so that when userpress the tab it will display the remaning days.

Wating for replies.

Regards

Moazam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Feb 16 2009
5 comments
21,718 views