ENDOFMONTH
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
Syntax
ENDOFMONTH(<date>)
Description
Returns the date of the last day of month (ending in the evening at 11:59:59.999 PM / 23:59:59.999) for the given date.
Examples
| Date | ENDOFMONTH returns |
|---|---|
| Oct 15, 2002 04:36:34 | Oct 31, 2002 11:59:59 PM |
| Apr 17, 2012 07:27:12 | Apr 30, 2012 11:59:59 PM |
| Jul 5, 1979 11:59:59 | Jul 31, 1979 11:59:59 PM |
Datameer X always uses the following format:
Three character month abbreviation (space) two digit day (comma)(space) four digit year (space) two digit hour (colon) two digit minute (colon) two digit second (space) two character meridiem notation.
(e.g., 12.01.2012 gets transferred to Jan 12, 2012 12:00:00 AM)
When selecting a pattern, you select the way the data gets parsed (your input format, this can be connected to your systems representation of dates and times).