Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleAvailability

This routine is available since starting with katl-commons 2.5.5

Syntax

...

endOfMonth(date)

Description

...

Excerpt

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

...

Code Block
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 (Content by label)
showLabelsfalse
max100
showSpacefalse
cqllabel = "date_routines"
labelsdate_routines