Microsoft KB Archive/817961

= Description of the behavior of the now function when you use it to create a filter and customize the current view of a folder in Outlook =

Article ID: 817961

Article Last Modified on 11/14/2006

-

APPLIES TO


 * Microsoft Office Outlook 2007
 * Microsoft Office Outlook 2003
 * Microsoft Outlook 2002 Standard Edition

-



SUMMARY
This article discusses the behavior of the now function when you use it to apply a filter to the current view of a folder in Microsoft Office Outlook 2007, in Microsoft Office Outlook 2003, and in Microsoft Outlook 2002.



MORE INFORMATION
The behavior of the now function is different between Outlook 2002 and later versions of Outlook when you use it to customize and apply a filter to the current view of a folder by using custom criteria on the Advanced tab of the Filter dialog box.

Outlook 2007 and Outlook 2003
When you use the now function to apply a filter to the current view by using custom criteria in the Advanced tab of the Filter dialog box (on the View menu, point to Arrange By, point to Current View, click Customize Current View, and then click Filter) in Outlook 2007 and in Outlook 2003, the now function in the Find items that match this criteria box of the SQL tab is resolved to the current date and time. That is, the date and time that is represented by the now function on the SQL tab changes to whatever the current date and time is at the time that you apply the filter.

For example, when you create a filter to display all the items that are sent on or after a specified date and time, and you set the value to now, only the items that are sent on or after the current date and time appear. When you click the SQL tab, the date and time that appears in the Find items that match this criteria box is the current date and time.

Outlook 2002
When you use the now function to apply a filter to the current view by using custom criteria in the Advanced tab of the Filter dialog box (on the View menu, point to Current View, click Customize Current View, and then click Filter) in Outlook 2002, the now function in the Find items that match this criteria box of the SQL tab is resolved to the date and time that you applied the filter. That is, the date and time that is represented by the now function on the SQL tab is resolved to an absolute time and does not change to reflect the current date and time.

For example, when you create a filter to display all the items that are sent on or after a specified date and time, and you set the value to now, only the items that are sent on or after the time and date that you applied the filter appear. When you click the SQL tab, the date and time that appears in the Find items that match this criteria box is the date and time that you originally created the filter.

Additional query words: OL2007 OL2003 OL2002

Keywords: kbfunctions kbinfo kbnofix KB817961

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.