Update Current View - Recently Added

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

When customizing a view in business contact manager I like to use the
recently added view. It lists the most recent 2 months of created contacts.

When going to customize view - and clkicking filter:
The SQL filter data looks like this:

(%thismonth("urn:schemas:calendar:created")% OR
%lastmonth("urn:schemas:calendar:created")%)

how do I make it list the contacts created since a certain date?
I have tried several filters, but have been unsuccessful.

Thank you.
 
Mike:

You could try this in the SQL filter and modify it to your needs--

("urn:schemas:calendar:created" >= '1/1/2008 12:00 AM'
AND
"urn:schemas:calendar:created" <= '2/29/2008 12:00 AM')

HTH,
Lon

___________________________________________________________
Lon Orenstein
pinpointtools, llc
(e-mail address removed)
Author of Outlook 2007 Business Contact Manager For Dummies
Author of the eBook: Moving from ACT! to Business Contact Manager
www.pinpointtools.com
 
Thank you Lon,
That was most helpful.
I did look in your book first....
Is it in there? I couldn't find it.
Cheers
 
Back
Top