Filter Based on Time

Question

Hi Team,

How to filter out lead records that are auto-created during non-office hours?

Like I need to show lead which is assigned  after 5 pm till 8:59 Am next day in OBIEE report

It's a daily report.

Only Friday is a holiday.

Office hours are from 9 am to 5 pm.

Thanks

User_F6761 · Answer

Thank You Gianni

I will check on it again.

Gianni Ceresa · Answer

A day finish at midnight, it doesn't continue the day after (that's what "tomorrow" is for).

Your filter must be on date AND time, not just time. Only on time a filter between 5pm and 8:59am makes no sense. At the best you could express it as between 5pm and midnight OR midnight and 8:59am, but this isn't what you said as it's on different days.

You must use date AND time...

User_F6761 · Answer

Hi

I had tried to add filter on datetime column after extracting the time just hh:mm:ss than I used " is between" operator on the column.

for values 5 pm between 11:59 pm getting the excepted results.

But when I try to filter like 5 pm between 8:59 am, i don't get any results.

pm to am is not working, i think next day data is not recognised.

Thanks