int __stdcall SFDB_ISWRKDY | ( | LONG | argDate, |
LPCTSTR | holidays, | ||
LPLONG | zDates, | ||
size_t | nSize, | ||
WORD | wkndNo | ||
) |
Examines a given date for weekends and holidays (non-working days), and returns FALSE if it falls on a non-working day; otherwise it returns TRUE.
- 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_DTADJUST()
- Parameters
[in] argDate is a serial date number that represents a given date [in] holidays is a (:_:) separated list of holiday names, calendars, countries or currency [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). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used.
NDK_RETCODE SFDB_ISWRKDY | ( | LONG | argDate, |
string | holidays, | ||
LONG[] | zDates, | ||
UIntPtr | nSize, | ||
UInt16 | wkndNo | ||
ref int | retVal | ||
) |
Examines a given date for weekends and holidays (non-working days), and returns FALSE if it falls on a non-working day; otherwise it returns TRUE.
- Returns
- status code of the operation
- Return values
-
NDK_SUCCESS Operation successful NDK_FAILED Operation unsuccessful. See Macros for full list.
- Parameters
[in] argDate is a serial date number that represents a given date [in] holidays is a (:_:) separated list of holiday names, calendars, countries or currency [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). If missing, the western weekend (i.e. 1, "Saturday, Sunday") is used.
- 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