website logo
ChartHop documentation
Carrot reference
Product updates
Navigate through spaces
ChartHop documentation
Carrot reference
Product updates
⌘K
Getting started
Getting started with Carrot
Operator precedence
Data categories
Basic Org Information
Compensation
Job Changes
Permissions
Personal
Recruiting
Structure
Time off
Data types
Address
Boolean
Comp
Comp Band
Currency
Date
DateTime
DaysOff
Enum
EnumList
File
Group
Image
Job
List
Money
Name
Number
Null
Percent
Person
PersonList
Shares
StockGrant
String
TimeOff
User
Operators
+ (add)
- (subtract)
* (multiply)
/ (divide)
% (modulus)
&& (and)
|| (or)
if
: (match)
= (equals)
!= (not-equals)
! (not)
> (greater-than)
>= (greater-than-equals)
< (less-than)
<= (less-than-equals)
[ ](array)
. (dot)
? (ternary)
?: (elvis)
Functions
abs()
boolean()
compHistory()
date()
day()
daysOffBetween()
diffYears()
diffMonths()
distance()
monthEnd()
formatMoney()
formatRound()
formatNumber()
formatPercent()
formatDate()
grantedShares()
length()
max()
mean()
money()
month()
min()
nextAnniversary()
number()
pluralize()
percent()
random()
round()
roundUp()
roundDown()
string()
subString()
stockPrice()
monthStart()
split()
vestValue()
vestShares()
year()
Aggregators
count{}
max{}
mean{}
min{}
sum{}
Docs powered by archbee 
4min

monthEnd()

Returns the last day of a given month.

Syntax

monthEnd([date])

  • date - (optional) the date from which to derive the last day of that date's month.
  • Return type: Date

Sample usage

monthEnd('2020-05-12') returns 2020-05-31.

Supported data types

Input type

Return type

Logic

Date

Date

The input date specifies the desired month. The month is then used to determine the final date in that month.

Unsupported data types

Null

Unsupported data types return Null.



Updated 24 Aug 2022
Did this page help you?
Yes
No
UP NEXT
formatMoney()
Docs powered by archbee 
Updated 24 Aug 2022
Did this page help you?
Yes
No
UP NEXT
formatMoney()
Docs powered by archbee 
TABLE OF CONTENTS
Syntax
Sample usage
Supported data types