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!

Controlling on Oracle Forms Date Range not more than 31 days.

515260Sep 17 2011 — edited Oct 2 2011

Respected all,

I need some help regarding oracle forms developer, in oracle report I have two date parameters :fmdate & :todate
, the requirement is , end user must not be able to extract data "more than a month" and end-user can extract data for 1 day more than two days and for a week as well.

I tried to restrict it at the report level by using functions such as trunc(:fmdate,'month') & last_day(:todate) and passing one :fromdate date parameter at the form level ... but it didn't work because it extracts one month data only. And suffice the requirement which is:
"end user must not be able to extract data "more than a month" and end-user can extract data for 1 day more than two days and for a week as well."

Some one have told me that it can control via RAISE_FORM_TRIGGER ... but I dont know how to use it.

I will be thankful to this forum, if someone help me out in this regard.

Regards

Edited by: user512257 on Sep 20, 2011 4:17 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2011

Added on Sep 17 2011

#data, #date, #forms, #moved-from-devops, #not, #on, #oracle

9 comments

922 views