EOMONTH Function

Contents:

If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Trifacta. See Product Editions.

Contents:

Returns the serial date number for the last day of the month before or after a specified number of months from a starting date.

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`

Examples

Tip: For additional examples, see Common Tasks.

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

See Also for EOMONTH Function:

Send Feedback

Page tree