endOfMonth

Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here !

Availability

This routine is available starting with SIL Engine™ 2.5.5

Syntax

endOfMonth(date)

Description

Returns a date set on the last day of the month for the given date. Also sets hours / minutes / seconds / milliseconds to their respective maximum value.

Parameters

Parameter name

Type

Required

Description

date

date

Yes

Specifies a Date expression.

Return type

date

Example

function endOfMonthToDesc(date d){
    desc += "End of month for date " + d + " is " + endOfMonth(d) + "\n";
}

desc = "";
endOfMonthToDesc("2013-01-26 20:19:18");
endOfMonthToDesc("2013-02-01 20:19:18");
endOfMonthToDesc("2012-02-01 20:19:18");
endOfMonthToDesc("2013-02-28 20:19:18");
endOfMonthToDesc("2012-02-29 20:19:18");
endOfMonthToDesc("2012-12-31 23:59:59");
endOfMonthToDesc("2012-12-31 00:00:00");
endOfMonthToDesc("2012-12-01 23:59:59");
endOfMonthToDesc("2012-12-01 00:00:00");

Outputs to description:

End of month for date 2013-01-26 20:19:18 is 2013-01-31 23:59:59

End of month for date 2013-02-01 20:19:18 is 2013-02-28 23:59:59

End of month for date 2012-02-01 20:19:18 is 2012-02-29 23:59:59

End of month for date 2013-02-28 20:19:18 is 2013-02-28 23:59:59

End of month for date 2012-02-29 20:19:18 is 2012-02-29 23:59:59

End of month for date 2012-12-31 23:59:59 is 2012-12-31 23:59:59

End of month for date 2012-12-31 00:00:00 is 2012-12-31 23:59:59

End of month for date 2012-12-01 23:59:59 is 2012-12-31 23:59:59

End of month for date 2012-12-01 00:00:00 is 2012-12-31 23:59:59


See also