• Subject: Outlook Restrict on SentOn (using Between)
  • Author: McKilty
  • Date: 28 Sep 2009
  • References:
Hello all,

I am trying to figure to the proper syntax for using Restrict on the
SentOn field. I need to restrict between two dates, but so far
nothing is filtering to the exact date range I'm looking for. I have
tried:

Set mItemCollection = mItemCollection.Restrict("[SentOn] > '" &
dteStart & "' AND [SentOn] < '" & dteEnd & "'")
Set mItemCollection = mItemCollection.Restrict("[SentOn] = '" &
dteStart & "'")
Set mItemCollection = mItemCollection.Restrict("[SentOn] Between '" &
dteStart & "' AND '" & dteEnd & "'")

Thanks for the help.
28 Sep 2009Outlook Restrict on SentOn (using Between).McKilty
28 Sep 2009\ Re: Outlook Restrict on SentOn (using Between).Sue Mosher [MVP]
28 Sep 2009   \ Re: Outlook Restrict on SentOn (using Between).McKilty
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)