| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| heading | 0 |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
|---|
| enableSorting | false |
|---|
|
Syntax | startOfMonth(date) | Package | | Alias | | Pkg Usage | |
|
Description
| Excerpt |
|---|
|
Returns a date set on the first day of the month for the given date. Also sets hours/minutes/seconds to 0. |
Returns a date set on the first day of the month for the given date. Also sets hours/minutes/seconds to 0.
...
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| enableSorting | false |
|---|
|
Parameter name | Type | Required | Description |
|---|
date | Date | Yes | Specifies a Date expression. |
|
Return Type
Date
Example
| Code Block |
|---|
|
function startOfMonthToDesc(date d){
desc += "Start of month for date " + d + " is " + startOfMonth(d) + "\n";
}
desc = "";
startOfMonthToDesc("2013-01-26 20:19:18");
startOfMonthToDesc("2013-02-01 20:19:18");
startOfMonthToDesc("2013-02-28 20:19:18");
startOfMonthToDesc("2012-02-29 20:19:18");
startOfMonthToDesc("2012-12-31 23:59:59");
startOfMonthToDesc("2012-12-01 23:59:59");
startOfMonthToDesc("2012-12-01 00:00:00"); |
...
Start of month for date 2012-12-01 00:00:00 is 2012-12-01 00:00:00
See also
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 25 |
|---|
| showSpace | false |
|---|
| cql | label = "date_routine" and space = currentSpace ( ) |
|---|
| labels | array_routines |
|---|
|
We've encountered an issue exporting this macro. Please try exporting this page again later.