Views - Filtering - SQL

  • Thread starter Thread starter ITMA
  • Start date Start date
I

ITMA

Does anyone know how to word a SQL statement to only show Tasks with a Due
Date of today or in the past/ I have tried various things to get it to
automatically know what 'today' is but it always reverts to inserting the
actual date, such that my criteria would not work the next day, only the day
the search was written
 
what things are you trying?

if you use the advanced tab and use start date is on or before today, it
uses "today". if you switch to the SQL tab, you'll see the SQL string it
creates.
"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}
/81040040" <= 'today'


--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours


http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone

Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
http://groups.google.com/groups?as_ugroup=microsoft.public.outlook.*&num=30
 
Yes, that's what I noticed, so I thought that would be OK, but after a
while, maybe after switching views or restarting outlook I noticed it had
substituted 'today' for today's actual date, hence my concern that come
tormorrow it would not work properly. The only thing I tried, with my
limited knowledge of office applications and VBA and SQL was 'now' and
'now()'
 
Back
Top