Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Start Date

End Date

(@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.

Former Member
Former Member replied

Hi Ven,

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.

Regards

Jacques

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question