How to display docs created between 8am and 5pm in a view

HCL Domino Domino Forum
1

I have a Native Notes Help Desk application and management wants to see how many documents are created between 8am and 5pm.

There’s a DeliveredDate field (Date/Time) on each document or I could use the Notes @Created

I have a view which shows documents created for the past 7 days: Here’s the Select code:

SELECT @All & @Contains(Subject;“TRANSFER CALL” :“TRANSFER CALL FROM SCRIPTWELCOME”) & @Adjust(@Created;0;0;7;0;0;0) > @Now

Example of column code for Sunday which has totals turned on:

@If(@Weekday(DeliveredDate)=1;1;0)

What would my select criteria need to be to display documents bewtween 8am and 5pm?

2

Subject: RE: How to display docs created between 8am and 5pm in a view

You can select documents in a particular hour range using @Hour(@Created) >= 8 & @Hour(@Created) < 5.

But I suggest it’s not really useful to know how many calls were logged in certain hours without knowing how many were logged during other hours, for comparison. Why wouldn’t you categorize by @Hour(@Created) within the days?

3

Subject: SOLVED IT: How to display docs created between 8am and 5pm in a view

Solved it. Here’s the code:

SELECT @All & @Contains(Subject;“TRANSFER CALL” :“TRANSFER CALL FROM SCRIPTWELCOME”) & @Adjust(@Created;0;0;7;0;0;0) > @Now

&

(@Time(DeliveredDate)>

@Time(7;59;59)) &

(@Time(DeliveredDate)<

@Time(17;00;01))