how to remove timestamp from datetime filed in a Webi report Prompt

[former_member215240]

Hi,

I have a requirement to show only date in Webi prompt but whereas the filed is in the format of date and timestamp. When we execute the report we have to see only date in prompt and datetimestamp in report output.

Please suggest.

Thanks and Regards

Santhosh

[Former Member]

Hi Santhosh,

Create a prompt with date format in Universe and use the same in Query Panel filter area for prompting it as date and use the direct field in report to display Date with Timestamp.

Regards,

G.Sainath

[former_member215240]

Thanks for the reply. I did the same way but I could see repeated date values in Prompt. How do I get unique values in prompt.

Thanks

Santhosh

[Former Member]

Use custom SQL with Keyword Distinct.