Advanced Filter for views

[Ian Buckley]

Hi, I'm trying to use the filter function to show certaiun dat in a view.
It appears to be giving me wrong info. I want to locat all records with a
date in a custom field betweeen two dates. It appears to be giving me all
the records. Is there any special way to put dates in?

 

[Sue Mosher [MVP]]

The Advanced tab should work for this. What filter criteria did you set?
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Ian Buckley]

Hi Sue,

I used a field from my custom form then "on or after 1/01/2003 12:00 am"

What I want to do is get the view to show me the records where there is a
date in the field - not the word "none". Say for example a date that falls
within this year. That's what I thought I did above. However it gives me
those with dates + the records with "none".

Many thanks for your much appreciated help!





The Advanced tab should work for this. What filter criteria did you set?
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Sue Mosher [MVP]]

"None" is actually the date #1/1/4501#. Unfortunately, the Filter dialog won't seem to take that value. The workaround is to use some other data that's high enough to be beyond the dates you want to filter. The filter "<mydatefield> between #1/1/2003# and #12/31/2003#" should fit your requirements.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Ian Buckley]

Thanks Sue,

I hadn't seen the "#" before. It works fine now. WHat is the "#" for?

Thanks




"None" is actually the date #1/1/4501#. Unfortunately, the Filter dialog
won't seem to take that value. The workaround is to use some other data
that's high enough to be beyond the dates you want to filter. The filter
"<mydatefield> between #1/1/2003# and #12/31/2003#" should fit your
requirements.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Sue Mosher [MVP]]

## is to dates what "" is to text -- it designates that the content is to be treated as a date.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers