Skip to Content

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

Unable to get database format for date object


I am using UDT to build an universe against Oracle DB, We are using a view to get date object to filter the dates in our reports. Format for the date column in the view is "dd-MMM-yy". Desired format at the WebI layer is also "dd-MMM-yy"

However, when I pull this object in WebI in filter pane, I am still getting Timestamp with date and the format is also coming as "mm/dd/yyy hh:mm:ss a"; and, if I pull the date column in results pane I am getting the correct format "dd-MMM-yy". I tried typing the value for prompt, using calender (this also gives default timestamp) none of them worked

I tried using with and with out the TRUNC(date) function, changed object properties at universe level but, still I am getting the same result

Can you please guide me on, how to get the date value in "dd-MMM-yy" when used in prompt and, is there a possibility to not show timestamp in calendar selection (screenshot: Date parameters2)

Thanks in advance


DB date format.JPG (23183 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question