Microsoft KB Archive/29325

{| = Excel: Using the NOW Function with Computed Criteria =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q29325

SUMMARY
To use the Microsoft Excel NOW function in criteria, computed criteria must be used.

For example, to find all records that have a date of at least 30 days ago (indicating that they are at least 30 days old), you would enter the following criteria

Computed Date =cell_ref<(NOW-30) where &quot;cell_ref&quot; is the relative reference to the first cell in the &quot;date&quot; field in the database. NOTE: &quot;Computed Date&quot; is used instead of &quot;Date&quot; because with computed criteria, the actual field name cannot be used; otherwise, Excel looks for a match of the formula as a text string.
 * }