Skip to main content

Date Functions

Designer Cloud Powered by Trifacta Enterprise Edition can process date information in a variety of sources. When date values are originally imported, they might be typed as String values due to inconsistencies in how they are represented. Using the functions below, you can set the formatting of your date values, so that they are consistently structured throughout your dataset.

Additionally, some of these functions enable you to extract numeric values from dates or to perform comparisons.

You can also convert date values between Unix time values and standard time values, which can be expressed to a precision of milliseconds.

Note

Other than the UNIXTIME function, date functions ignore time zone in Datetime values.

Date ranges:

Valid dates fit in the following range: 01/01/1400 to 12/31/2599.