| int __stdcall SFDB_WKNDate | ( | LONG | argDate, |
| LPCTSTR | holidays, | ||
| LPLONG | zDates, | ||
| size_t | nSize, | ||
| WORD | wkndNo, | ||
| WORD | wkdOption, | ||
| WORD | direction, | ||
| LPLONG | retVal | ||
| ) |
Returns the serial date number that corresponds to the first (last) day in the next (last) weekend.
- 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] wkndNo is the weekend number (1-7, 11-17). [in] wkdOption is a switch to specify how to test for short or long weekends (1 = all (default), 2 = ignore holidays, 3 = only short weekends, 4 = only long weekends). [in] direction is a switch to select the return output (1 = next weekend (default), 2 = last weekend). [out] retVal is the serial date number of the next/previous weekend
| int SFDB_WKNDate | ( | Long | argDate, |
| string | holidays, | ||
| long[] | zDates, | ||
| UIntPtr | nSize, | ||
| UInt16 | wkndNo, | ||
| UInt16 | wkdOption, | ||
| UInt16 | direction, | ||
| ref long | retVal | ||
| ) |
Returns the serial date number that corresponds to the first (last) day in the next (last) weekend.
- Returns
- status code of the operation
- Return values
NDK_SUCCESS returns an integer
- 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] wkndNo is the weekend number (1-7, 11-17). [in] wkdOption is a switch to specify how to test for short or long weekends (1 = all (default), 2 = ignore holidays, 3 = only short weekends, 4 = only long weekends). [in] direction is a switch to select the return output (1 = next weekend (default), 2 = last weekend). [out] retVal is the serial date number of the next/previous 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
