1 Reply Latest reply on Oct 1, 2013 12:53 PM by Dan Cory

    How is the date represented in a parameter?

    Elizabeth Do

      I'm trying to create a custom SQL using Oracle where I pass in a date to filter the data I pull from the database. (V8)

       

      I created a date parameter, and then in the custom SQL I use the 'Add Parameter' button to add the date to the SQL. However I get the message that the month is invalid.

       

      I know in a date parameter, you may see the value as well as select a display format, but is the display format you choose what is being outputted to the SQL? If not, what format is the date being outputted to the SQL? Is there a way to set it?