Microsoft KB Archive/58701

Multiplan: Using Comparison Operators to Query Dates PSS ID Number: Q58701 Article last modified on 03-28-1990 PSS database name: D_MPlan

4.00 4.01 4.20

MS-DOS

Summary:

To use the comparison operators (greater than, less than, or equal to) to find a range of dates in a Multiplan Versions 4.x database, the dates must be entered into their cells as text using the DATE function along with the desired comparison operator.

The following are examples:

(DATE(YY,MM,DD)

DATE(85,12,31) <DATE(90,1,15) =DATE(81,10,25) Copyright Microsoft Corporation 1990.