Filter end date works differently in OL'07/OL'10 vs OL'03? Hello?!

Status
Not open for further replies.

northbanker

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
This is related to may last thread but I decided to start a new one since it's kind of general...

For years I've been using Adv.Find in OL'03 and searching for calendar items with start dates BETWEEN date1 and date2.

With OL'03 this range was always INCLUSIVE, i.e. it matched up through and including date2.

But with OL'07 & OL'10, I just discovered that the BETWEEN date-range filter is NOT INCLUSIVE! It matches up through date2-MINUS-ONE-day.

Wow, this forces me to undo 10+ years of ingrained understanding of Outlook date ranges!

But I'm baffled as to WHY would Microsoft would change this?! :confused: :mad:

When most people do date-ranges don't they think of the end date as included in the range??
 
That's a feature (or limitation :)) of instant search. You can do an inclusive search by using 2 periods between the dates or adding equal signs




received: (1/15/10..6/15/10) or received:(>=1/15/2010 AND <=4/15/2010)




more tips are at http://www.slipstick.com/outlook/instant-search-tips/
 
That's a feature (or limitation :)) of instant search. You can do an inclusive search by using 2 periods between the dates or adding equal signs

received: (1/15/10..6/15/10) or received:(>=1/15/2010 AND <=4/15/2010)

more tips are at http://www.slipstick.com/outlook/instant-search-tips/

Thanks Diane. But these don't seem to work for me.

I'm not using Instant Search, I'm using the View/ViewSettings/Filter mechanism. If "date1 AND <=date2" worked I could probably get used to using the "<=" all the time. But alas it didn't work in my test.
 
Oh, yeah, that won't work in filters. I wasn't aware the behavior in filters changed.
 
That's an understatement. :) Advanced find uses the instant search index so it makes sense, but it certainly wasn't expected.
 
Can anyone think of any creative workaround so that I could still use FILTER for date ranges, and still acheive an inclusive end date? <he asks with a modicum of hope>
 
Use Query Builder and two rules- on or before start-date AND on or after end-date. This won't work in Advanced field - that will OR the conditions together.




If you want to use the Advanced tab, add a day at the end - here 'between' finds all messages on the first date but not on the last, so instead of 10/1 and 10/31, you need to use 10/1 and 11/1.
 
Use Query Builder and two rules- on or before start-date AND on or after end-date. This won't work in Advanced field - that will OR the conditions together.

If you want to use the Advanced tab, add a day at the end - here 'between' finds all messages on the first date but not on the last, so instead of 10/1 and 10/31, you need to use 10/1 and 11/1.

Diane, the 2nd suggestion (adding an extra day to end-date under Advanced tab) is what I'm doing but it's counterintuitive, contrary to 10+ of ingrained knowledge, and thus a big dangerous.

Before making my next date range, I usually base it on the date range last used a few weeks/months ago, i.e. 10/1 thru 10/15. So the next range I want records to match is 10/16 thru 10/31.

BUT if I use the Adv.Find add-an-extra-day workaround, then my ranges must be 10/1 thru 10/16, and next time 10/16 thru 11/1, then 11/1 thru 11/16, etc. IOW, I always have to be sure to overlap the last end date with next start date.

I'm a little worried I'll make a mistake, and in my context, missing a day could be a monetary accounting problem.

So... your 1st idea (QUERY BUILDER) is VERY intriguing! I tried it out and it seems to work great!

The only real downside I see is that it's a 2-step process to remove 2 query lines and replace them w/ the new dates, whereas with Adv.Find it's a 1-step process.

BUT your Query Builder idea has the BIG advantage of using dates in the same intuitive, inclusive way, that I've been used to for many years.

So I think I may just use Query Builder. So thanks again!!! ...for pointing out something I shoulda figured out myself ;)
 
Yes transcripts

Thanks Mistikuss but I'm careful about what links I click, and when I see .RU I tend to avoid becuase of their malware repuation. ;) So if your suggestion is any different than Diane's Query Builder one, could you give me a quick summary?
 
I think the transcripts post was spam - i didn't notice the icon was not one of ours.




Because of the way you work, Query builder looks to be the best - you could change the on or after to on or before in the one condition, but i don't think it will save much time as the other criteria will need edited both for the date and the condition.
 
Yes I thought the .RU link post might be spam.

As for Query Builder the only way I see to edit a condition (to change a date) is to remove each condition, change the date, then add it back. That's the only way, right?
 
I don't have it enabled on this computer (I'm still putting it back together after icloud killed it), but my recollection is that it works like the advanced tab - select a condition, click remove and it drops it to the field so you can edit it. I'll double check when i get back to my office.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R unable to filter tasks when start date is on or before today Using Outlook 3
O Filter-Query Builder-Description - what field name to use? Using Outlook 4
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
Jennifer Murphy Spam filter not working Using Outlook 13
Y Filter unread emails in a search folder vba help Outlook VBA and Custom Forms 0
M How create a Rule to filter sender's email with more that one @ sign Using Outlook 1
M Sorting by Day in Date Column Advanced Filter BCM (Business Contact Manager) 1
Z Task Filter Not Working When I add too many criteria Using Outlook 0
M Filter Conversations - Filter Out Single Emails Outlook VBA and Custom Forms 3
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
B Wanting to run a script that will filter any body that has a russian link in it. Outlook VBA and Custom Forms 5
C Filter/Search emails sent to internal Exchange address only Using Outlook 2
e_a_g_l_e_p_i Is there a good third party SPAM filter that intergrates with Outlook 2010 Using Outlook 7
P How to filter primary contacts in business contact manager BCM (Business Contact Manager) 0
O Outlook Web Access - how to disable spam filter Using Outlook 6
G How to filter by the format of an email address Using Outlook 6
S Mail filter recieved before the last 2 working days Using Outlook 1
Liza Creating a rule in outlook to filter messages Using Outlook 0
F Adding textbox filter to listbox? Outlook VBA and Custom Forms 2
Diane Poremsky Filter and Save Contacts to a CSV File Using Outlook 0
Diane Poremsky Filter and Save Contacts to a CSV File Using Outlook 0
Fozzie Bear HomeTab Email filter "Greyed Out" in Outlook 2013 Exchange Server Administration 3
W Filter condition "contains"/"doesn't contain" doesn't always work Using Outlook 10
B Conditional Formatting:How to use >1 value in a filter Using Outlook 7
J Outlook VBA for Email Filter Outlook VBA and Custom Forms 2
Emerogork How do I set up an "Incoming mail filter" Using Outlook 12
M Filter today's mail Using Outlook 2
M trying to disable junk email filter. completely. Using Outlook 4
J Task Filter for Status OR One Month Using Outlook 4
R Filter Views by Category Using Outlook 2
D Junk Mail filter Using Outlook 1
S Filter by accounts but communicate to all linked contacts BCM (Business Contact Manager) 1
D What is this SQL filter that is applied to my Inbox? Using Outlook 6
J Outlook Contacts: How to filter contact phone numbers from a cti request Using Outlook 1
H Two accounts, Junk email filter only works on one account, office 2010, pop3 Using Outlook 5
D How Would I Write This Filter? Using Outlook 3
williamlambton Filter which removes Display Names from incoming emails. Using Outlook 2
J How to filter by address fragment (e.g. "@domain.com") with advanced find? Using Outlook 2
L Need a good email filter Using Outlook 2
P BCM Review & Filter BCM (Business Contact Manager) 1
M DASL Filter function? Outlook VBA and Custom Forms 3
M DASL Filter function? Outlook VBA and Custom Forms 3
M Today(S) function in DASL Filter Outlook VBA and Custom Forms 1
M Today(S) function in DASL Filter Outlook VBA and Custom Forms 1
M Create search folder filter that converts UTC time to local? Outlook VBA and Custom Forms 9
E DASL Filter doesn't work when defined programatically Outlook VBA and Custom Forms 1
H Outlook 2007 SQL syntax to filter views of tasks and todo items Outlook VBA and Custom Forms 1
K Can I filter by fields 'containing' specific words? BCM (Business Contact Manager) 1
P Custom rule to filter on sender name Outlook VBA and Custom Forms 5

Similar threads

Back
Top