BI Publisher (MOSC)

MOSC Banner

datetime parameter in BI report

I have a BI report in Oracle ERP where I want to select data since the last time the report was run, so to do that I have created a last update date Date parameter. It works for dates, but not date times. Is there a way to get it to work with a datetime parameter? The user would like to be able to run the report multiple times per day and only get the items that changed since the last run, which requires datetime and not just date.

I tried setting the date format string to yyyy-MM-dd'T'HH:mm:ss.SSS'Z' but although it accepts the format string, when I run the report it tells me the parameter is missing.

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