int __stdcall SFDB_WKNDur | ( | LONG | argDate, |
LPCTSTR | holidays, | ||
LPLONG | zDates, | ||
size_t | nSize, | ||
WORD | nWkndNo, | ||
LPWORD | retVal | ||
) |
Returns the duration (in calendar days) of the (long) weekend that a given day falls on.
- Returns
- status code of the operation
- Return values
NDK_SUCCESS Operation successful NDK_FAILED Operation unsuccessful. See SFMacros.h for more details.
- See Also
- SFDB_ISWRKDY()
- Parameters
[in] argDate is a serial date number that represents a given date [in] holidays is a (:_:) separated list of holiday codes [in] zDates is an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970) [in] nSize is the number of holiday dates in zDates [in] nWkndNo is the weekend number (1-7, 11-17). [out] retVal is the number of calendar days in the given weekend
int SFDB_WKNDur | ( | Long | argDate, |
string | holidays, | ||
Long[] | zDates, | ||
UIntPtr | nSize, | ||
UInt16 | nWkndNo, | ||
UInt16 | retVal | ||
) |
Returns the duration (in calendar days) of the (long) weekend that a given day falls on.
- Returns
- status code of the operation
- Return values
Date serial date of the first and last day of the weekend
- Parameters
[in] argDate is a serial date number that represents a given date [in] holidays is a (:_:) separated list of holiday codes [in] zDates is an array of holidays dates; each expressed as a serial number (i.e. number of days since 1.1.1970) [in] nSize is the number of holiday dates in zDates [in] nWkndNo is the weekend number (1-7, 11-17). [out] retVal is the number of calendar days in the given weekend
- Remarks
- Exceptions
-
Exception Type Condition None N/A
- Requirements
-
Namespace NumXLAPI Class SFDBM Scope Public Lifetime Static Package NumXLAPI.DLL
- Examples
- References
- * Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
- * Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740
- * D. S.G. Pollock; Handbook of Time Series Analysis, Signal Processing, and Dynamics; Academic Press; Har/Cdr edition(Nov 17, 1999), ISBN: 125609906
- * Box, Jenkins and Reisel; Time Series Analysis: Forecasting and Control; John Wiley & SONS.; 4th edition(Jun 30, 2008), ISBN: 470272848