My Oracle Support Banner

How to Pass a User Date Parameter as 'YYYY' to Drilldown Report (Doc ID 1040897.6)

Last updated on SEPTEMBER 01, 2023

Applies to:

Oracle Reports Developer - Version and later
Information in this document applies to any platform.



The user date parameter is stored as YY format within a report so that when

you try to pass this via SRW.RUN_REPORT to a drilldown report requiring a

YYYY date format for the input user date, the century does not come over as

YYYY (and thus loses the 20 of the 21st century).

Using 'RR' or 'RRRR' format in the primary report is irrelevant for passing

the date and the receiving drilldown report does not recognize the century

difference no matter how you set up the two reports.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.