Issue with Date prompt - Datetime getting included as suffix by default

[mgowrishankar]

Hi,

I have created a derived table and wanted to pass date prompt to run for the selected date values. When I select date in prompt, timestamp is automatically getting added as suffix in both IDT and Webi. How to avoid timestamp in date prompt and pass only the date is selected.

Am unable to access this SAP Note (1741062 - Unable to remove timestamp from calendar prompt by

modifying ObjectFormat.xml file on BI4.0

) If anyone could share the content of this note, that would be helpful. Am using BI4.2 SP 6 Patch 7 version.

Thank you

[nscheaffer]

In IDT, if you make the datatype of your object "Date" rather than "Datetime" it will work how you want.