Microsoft KB Archive/58701: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - "<" to "<") |
||
| Line 13: | Line 13: | ||
(DATE(YY,MM,DD) | (DATE(YY,MM,DD) | ||
<blockquote>DATE(85,12,31) | <blockquote>DATE(85,12,31) <DATE(90,1,15) =DATE(81,10,25) | ||
</blockquote> | </blockquote> | ||
Copyright Microsoft Corporation 1990. | Copyright Microsoft Corporation 1990. | ||
Revision as of 09:34, 21 July 2020
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.
