You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Model Default parameter to current period

On a Data Model for a report I have a parameter for the period that I would like to default to the current period. The parameter is a Data Type of Date and a Parameter Type of Date. When I try setting the default value to {TO_CHAR(SYSDATE,'Mon-YY','NLS_DATE_LANGUAGE=AMERICAN')} I receive an error of Invalid Date Format. When I use {$SYSDATE()$} it does default to the current date but I need the current period

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!