Specifying Date Based SQL Filter for Custom Calendar View

S

Steven Reid

Hi all,

I am trying to create a table view within Outlook 2003 (11.5608.5703)
that will only show entries where the start date is within the last
two months.

Going in and setting the filter to say all items where the start date
is in the last month gives me
%lastmonth("urn:schemas:calendar:dtstart")%
or using the modified date gives me %lastmonth("DAV:getlastmodified")%
in the SQL tab.

But i need something for the last two months.

I have tried to create a user defined field (udf) in the folder which
uses the datediff function to show number of months since the start
date ie. datediff('m',now(), [startdate])

but when I try to filter on this field it does not show up in the user
defined fields.

Any suggestions?

Thanks
Steven Reid
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to view the complete data in filter 0
SSRS Date Formatting Question 2
Using an IIF Statement to calculate discharge date 4
Can I use "OR" in two auto-filters/custom filters? 1
Filter appointments starting or finishing after a certain time 1
Today(S) function in DASL Filter 1
Eliminating Dates based on a measure 1
Date Comparison 3

Top