BI Publisher (MOSC)

MOSC Banner

BI Publisher, create Parameter from date field formatted like: 10/22/2010 2:31:14 PM and stored as d

edited Nov 4, 2019 1:12PM in BI Publisher (MOSC) 7 commentsAnswered ✓

Trying to build a parameter in BI Publisher that will filter the results on date.  Can create the parameter but the parameter does not filter the results by the value entered.  Advised in an SR to use TO_CHAR when creating the data model and then create the Data Type as String and the Parameter Type as Date.  BIP will allow string format on creation but will not maintain that state after saving. When returning to the parameter, the Data Type reverts to Date.   Tried many other approaches including multiple formats using TO_CHAR in the data model but these all fail. 

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