This function returns a number representing the timestamp for the last day of the month of a given timestamp in a specific time zone.

The timestamp returns 00:00 i.e., the very beginning of the last day.


lastDayOfTheMonth(timestamp, timeZone) #Output: Number



Parser expressionDescription


lastDayOfTheMonth(2020/02/05 11:31, LOCAL)


This example returns: 2020/02/28 00:00.


lastDayOfTheMonth({issue.created}, LOCAL)


This example returns the timestamp of the last day of the month an issue was created.



Parameters used in this function

ParameterInput (data type)Description
timestamp

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
timeZone

The time zone used for the calculation. 


Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 



This function returns a



Use cases and examples



Parser function cloud
Map(question)
Notes

Workaround

%{stringToDate(toString(year({issue.created}, RUN_AS_LOCAL)) + "/" +
toString(month({issue.created}, RUN_AS_LOCAL)) + "/" +
toString(getMatchingValue(month({issue.created}, RUN_AS_LOCAL),
[1,2,3,4,5,6,7,8,9,10,11,12], [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31])), RUN_AS_LOCAL)}







Status
Tech review

Style guide




Short description

Returns the last day of the month of a given timestamp.

Output

Available since

Label