Script for date range in oracle forms
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 ');