Technology Stack - EBS (MOSC)

MOSC Banner

Script for date range in oracle forms

edited Aug 20, 2021 11:01AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hello Team

I have designed one custom form and added from date and to_date  search fields.

I need to enter the date in this text item, so that i would receive the data within the date range.

/**This is my script **/

if :CONTROL.FROM_DATE is null

then

go_block('XX_PO_PAYMENT_V');

execute_query();

else if length(:CONTROL.FROM_DATE)  > 0

then

go_block('XX_PO_PAYMENT_V');

--set_block_property('XX_PO_PAYMENT_V',DEFAULT_WHERE,'PO_DATE>=:CONTROL.FROM_DATE');

set_block_property('XX_PO_PAYMENT_V',DEFAULT_WHERE,'PO_DATE BETWEEN :CONTROL.FROM_DATE  AND :CONTROL.TO_DATE ');

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center