QS.CALENDAR.IS.END.OF.MONTH¶
Checks whether Following adjustment of the next day crosses a month boundary
Category: QuantSupport - Time.
- QS.CALENDAR.IS.END.OF.MONTH(date: text, calendar: text) logical¶
- Parameters:
date (text) – ISO date text in YYYY-MM-DD format within 1902-01-01..2198-12-31
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
- Returns:
TRUE when Following adjustment of date + 1 crosses into another month. This native predicate can also be TRUE on non-business days after the last business day; it is not an equality check against END.OF.MONTH.
- Return Type:
logical
- Errors:
#VALUE! for an invalid canonical calendar or ISO date, or a date outside 1902-01-01..2198-12-31.
Formula¶
=QS.CALENDAR.IS.END.OF.MONTH(date, calendar)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_is_end_of_month (date : & str , calendar : & str) -> Result < bool , XllError >