On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.
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.