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?
The date parameter is formatted as a date in the appropriate SQL dialect. So as long as your custom SQL expects a date, it should be fine.