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.
