Skip to end of banner
Go to start of banner

endOfMonth

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

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

Filter by label

There are no items with the selected labels at this time.

We've encountered an issue exporting this macro. Please try exporting this page again later.
  • No labels