Parameter
|
Description
|
---|---|
StartDate
|
The field or value to use as the starting date of the span.
|
EndDate
|
The field or value to use as the ending date of the span.
|
EndOption
|
Indicates what should happen if the EndDate is blank or zero. Choices are:
• OPTIONAL_RESULT — When selected (default), the result of the function is the OptionalValue.
• OPTIONAL_ENDDATE — When selected, the result of the function is the difference between the OptionalValue and the StartDate (OptionalValue − StartDate) rather than the End Date and the Start Date (EndDate − StartDate).
|
OptionalValue
|
Specifies the value to use for the optional value when the EndDate is blank or zero. The default is BLANK, which means that a blank is stored as the result for the field. However, if a value is specified, the Start Date would be subtracted from this value (OptionalValue − StartDate) and that result would be stored instead.
|