Date format in Universe as prompt
I have a feild curr_dt_time in database and I need to create prompt with date range so that user can select a date range in the report.
I have created two prompts in Universe
(@Select(DateTable\Current Date Time) IN to_date(@Prompt('Select Start Date','D','DateTable\Current Date Time',free,Persistent),'MM-DD-YYYY'))
(@Select(DateTable\Current Date Time) IN to_date(@Prompt('Select End Date','D','DateTable\Current Date Time',free,Persistent),'MM-DD-YYYY'))
which parsed successfuly.
I used to_date function because user has to see only date not time.
When I use this prompts in my report level, getting below error.
Error ORA-08130:date format picture ends before converting entire input string
Please share your thougths and let me know where I am going wrong.
Also, I need to select the date range values in my report. How do I do that.
The syntax I gave is abreviated and is to be used in the universe.
If you need to do this prompting in at report level, then the query panel has all the functions available in a nice drag and drop fashion.