Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Contents:


 Add a specified number of units to a valid date. Units can be any supported Datetime unit (e.g. minute, month, year, etc.). Input must be a column reference containing dates.

NOTE: If this function computes values out of the supported range of dates, the values are written as mismatched values, and the column is likely to be typed as a Datetime column. For more information on supported date ranges, see Datetime Data Type.


Basic Usage

derive value:DATEADD(myDate, 3, month)

Output: Generates a column of values calculating the values in the myDate column with three months added to them. 

NOTE: Output dates are always formatted with dashes. For example, if the input values include 12/31/2016, a DATEADD function output might be 03-31-2016.

 

Syntax

derive value:DATEADD(date,delta,date_units)

ArgumentRequired?Data TypeDescription
dateYdatetimeStarting date to compare
deltaYintegerNumber of units to apply to the date value.
date_unitsYstringString literal representing the date units to use in the comparison

For more information on syntax standards, see Language Documentation Syntax Notes.

date

Date values to which to add. It must be a column reference.

Usage Notes:

 

Required?Data TypeExample Value
YesString (Date column reference)LastContactDate

delta

Number of units to apply to the date values.

  • Negative integer values are accepted.

Usage Notes:

Required?Data TypeExample Value
YesInteger-3

date_units

Unit of date measurement to which to apply the delta value.

Usage Notes:

Required?Data TypeExample Value
YesStringyear

Accepted Value for date units:

  • year
  • quarter
  • month
  • dayofyear

  • day
  • hour
  • minute
  • second
  • millisecond

Examples

Example - DATEADD Function

Source:

Here are some example invoices and their dates. You want to calculate the 90-day and 180-day limits, at which point interest is charged.

InvNumInvDate
inv00011/1/2016
inv00027/15/2016
inv000312/30/2016

Transform:

derive value:DATEADD(InvDate,90,day) as:'plus90'

derive value:DATEADD(InvDate,180,day) as:'plus180'

Results:

NOTE: The output format is always formatted with dashes.

InvNumInvDateplus90plus180
inv00011/1/20163-31-20166-29-2016
inv00027/15/201610-13-20161-11-2017
inv000312/30/20163-30-20176-28-2017

 

Your Rating: Results: PatheticBadOKGoodOutstanding! 2 rates

This page has no comments.