Page tree

Trifacta Dataprep


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.


Dataprep by Trifacta® 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.


This page has no comments.