Microsoft KB Archive/39781

= Microsoft Knowledge Base =

File: Using Dates in Formulas
Last reviewed: October 27, 1994

Article ID: Q39781

Summary:

In Microsoft File version 2.00, formulas can be created in Date fields and Date fields can be used in formulas. If the result should be a date, format a Date field as computed. If the result should be a number, format a Number field as computed.

More Information:

For example, to compute the value of an &quot;Overdue&quot; field (a computed Number field) subtract the &quot;Payment due date&quot; field from the current date.

If the current date is 12/25/90, enter the following formula in the &quot;Overdue&quot; computed field:

&quot;12/25/90&quot; - Payment Due File will calculate the difference in the number of days between these two values to determine the number of days each invoice is overdue. File enters the value in the &quot;Overdue&quot; field.

Note: A date must be enclosed in quotation marks when it is entered as part of a formula.