Contents:
Contents:
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
eomonth(myDate, 3)
Output: Returns the values for the last date of the month that is three months after the serial date number value in the myDate column.
Syntax and Arguments
eomonth(start_date,delta_months)
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| start_date | Y | Datetime | Starting date. |
| delta_months | Y | integer | Number of months before or after the starting date to apply to the date value. |
For more information on syntax standards, see Language Documentation Syntax Notes.
start_date
Starting date values from which to compute end-of-month values.
Usage Notes:
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Literal Datetime or column reference | LastContactDate |
delta_months
Number of months to add to the date value to determine the month whose last date is returned.
- Negative integer values are accepted.
Usage Notes:
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Integer | -3
|
Tip: For additional examples, see Common Tasks.
Examples
Example - EOMONTH Function
Source:
In the following table, you can see how the the end-of-month values are calculated from a baseline date of June 15, 2020.
| eventId | eventDate | deltaMonth |
|---|---|---|
| 1 | 06/15/2020 | -24 |
| 2 | 06/15/2020 | -18 |
| 3 | 06/15/2020 | -12 |
| 4 | 06/15/2020 | -6 |
| 5 | 06/15/2020 | -3 |
| 6 | 06/15/2020 | -2 |
| 7 | 06/15/2020 | -1 |
| 8 | 06/15/2020 | 0 |
| 9 | 06/15/2020 | 1 |
| 10 | 06/15/2020 | 2 |
| 11 | 06/15/2020 | 3 |
| 12 | 06/15/2020 | 6 |
| 13 | 06/15/2020 | 12 |
| 14 | 06/15/2020 | 18 |
| 15 | 06/15/2020 | 24 |
Transformation:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | eomonth(eventDate,deltaMonth) |
| Parameter: New column name | 'deltaMonthSerialDate' |
Results:
| eventId | eventDate | deltaMonth | deltaMonthSerialDate |
|---|---|---|---|
| 1 | 06/15/2020 | -24 | 43281 |
| 2 | 06/15/2020 | -18 | 43465 |
| 3 | 06/15/2020 | -12 | 43646 |
| 4 | 06/15/2020 | -6 | 43830 |
| 5 | 06/15/2020 | -3 | 43921 |
| 6 | 06/15/2020 | -2 | 43951 |
| 7 | 06/15/2020 | -1 | 43982 |
| 8 | 06/15/2020 | 0 | 44012 |
| 9 | 06/15/2020 | 1 | 44043 |
| 10 | 06/15/2020 | 2 | 44074 |
| 11 | 06/15/2020 | 3 | 44104 |
| 12 | 06/15/2020 | 6 | 44196 |
| 13 | 06/15/2020 | 12 | 44377 |
| 14 | 06/15/2020 | 18 | 44561 |
| 15 | 06/15/2020 | 24 | 44742 |
This page has no comments.