Danny Child
asked on
Search for emails by TIME, not date - o2003
Hi,
can I search a mailbox for emails within a certain time window? For instance - between 17:00 and 23:59?
I've tried the standard search ..Advanced Tab.. Date and Time.. Sent.. Between.. 17:00 and 23:59
and similar permutations, but they either return nothing, or everything...
A filter would also work ok, but I get the same problem - I guess the search and filter use similar formats.
Needed to identify work done out of hours - searching Inbox and Sent Items primarily, or everything....
thanks,
Danny
can I search a mailbox for emails within a certain time window? For instance - between 17:00 and 23:59?
I've tried the standard search ..Advanced Tab.. Date and Time.. Sent.. Between.. 17:00 and 23:59
and similar permutations, but they either return nothing, or everything...
A filter would also work ok, but I get the same problem - I guess the search and filter use similar formats.
Needed to identify work done out of hours - searching Inbox and Sent Items primarily, or everything....
thanks,
Danny
ASKER
That would work, but if it's a chore, then don't bother. This isn't a showstopper issue. Happy to bump the points tho! (like you need them....!)
I saw the SQL query options in the Find dialog, is that any cleverer/easier? But as I know burger all about SQL queries, I can't suss it myself.
ta for the reply tho.
I saw the SQL query options in the Find dialog, is that any cleverer/easier? But as I know burger all about SQL queries, I can't suss it myself.
ta for the reply tho.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
looks good. I'm having a bit of a mental day here, will get to test it soon.
please bear with me...
Danny
please bear with me...
Danny
No problem, Danny. Take your time. I'll be here.
I can do this with a bit of scripting if that's an option.
Cheers!