syntax:functions:monthend
Differences
This shows you the differences between two versions of the page.
syntax:functions:monthend [2018/08/13 16:12] – created dmitry | syntax:functions:monthend [2021/09/10 22:27] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== MonthEnd(date_as_number) ===== | + | ====== MonthEnd(date) ====== |
+ | Category: | ||
- | Returns | + | \\ |
+ | =====Description===== | ||
+ | This function returns the date serial number of the last day of the month //date// falls in. | ||
+ | |||
+ | \\ | ||
+ | =====Arguments===== | ||
+ | ^Argument^Type^Description^ | ||
+ | |date|Date or Number (date serial)|An expression representing a date to derive the month' | ||
+ | |||
+ | **Return value type:** Date serial number | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | The //date// argument can take any value or expression that evaluates to a date serial value. | ||
+ | * A date string: | ||
+ | * A date serial value: 43811 (the date serial for " | ||
+ | * A date value created using any of the Date/Time functions that returns a date serial value. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | monthend(# | ||
+ | |||
+ | monthend(# | ||
+ | |||
+ | day( monthend( #2019-01-10 ) ) //Returns 31 (Combined with the Day function, only the day number is returned.) | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
+ | * [[syntax: | ||
- | ^ Example | ||
- | | monthend(# |
syntax/functions/monthend.1534191169.txt.gz · Last modified: 2018/08/13 16:12 by dmitry