syntax:functions:monthend
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revision | |||
— | syntax:functions:monthend [2021/09/10 22:27] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== MonthEnd(date) ====== | ||
+ | Category: | ||
+ | |||
+ | \\ | ||
+ | =====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: | ||
syntax/functions/monthend.txt · Last modified: 2021/09/10 22:27 by craigt