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!

Passing Date parameter to a report

Eslam_ElbyalyNov 7 2016 — edited Nov 13 2016

hi ,

i am working with forms and reports [32 Bit] Version 6.0.8.26.0 (Production) ,

i have a form with 2 date parameters with format mask 'DD/MM/YYYY' ,

I send the params to the report which has 2 parameters with same names and same format masks .

this is the way i send the parameter

  ADD_PARAMETER(PLID,'FROM_DATE',TEXT_PARAMETER,:B.FROM_DATE);

when i show the param form with

ADD_PARAMETER(PLID,'PARAMFORM',TEXT_PARAMETER,'YES');

I see dates with another format , something like ' JAN-06-2016' .

Why the format changes ?

i am asking because i did not retrieve data at some point . -- i do not remember the criteria i used , but i can try again if you need that to answer my question .

thank you so much

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2016
Added on Nov 7 2016
2 comments
4,442 views