Download Progress Results User`s Guide for Windows

Transcript
Progress Results User’s Guide for Windows
Table 6–4:
Date Functions
Function
6–26
(2 of 2)
Description
Earlier of Two Dates
Returns the earlier of two dates. For example, if the
function compares the dates 01/05/95 and 01/09/99, it
returns 01/05/95.
If first expression is true
return second else third
date
Defines an expression that makes a decision. If the first part
of the expression is true, the function returns the second
date; if the first part of the expression is not true, the
function returns the third date.
Later of Two Dates
Returns the later of two dates. For example, if the function
compares the dates 01/05/95 and 01/09/99, it returns
01/09/99.
Month of Year
Returns the number of the month for the date you specify.
Subtract Days from
Date Value
Subtracts the number of days you specify from a date and
returns the value.
Year Value
Returns the year for the date you specify. For example, the
date 04/05/99 is returned as 1999.