Skip to Content
0

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

Dec 28, 2017 at 08:08 PM

153

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 28, 2017 at 10:18 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Former Member

Use custom SQL with Keyword Distinct.

0