Skip to Content
0

Specific time frame for reports Webi

Jan 24, 2017 at 04:14 PM

26

avatar image

Hello all,

I would like to run a report that brings in data when the [date] is between specific time frame- 8.00 to 6.00 PM. What formula can I use for this?

Thank you

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

2 Answers

AMIT KUMAR
Jan 24, 2017 at 04:28 PM
0

Extract timepart in additional object in universe and add the webi query filter where timeobject greater then 8.00 and less then 6.00.

if you want to do this at report level again same concept extract the time part in one variable and apply the report/table level filter to restrict the data.

Share
10 |10000 characters needed characters left characters exceeded
Dani N Jan 27, 2017 at 03:22 PM
0

How do I extract the timepart from a datetime? Could you please provide suggestions.

Share
10 |10000 characters needed characters left characters exceeded