Page tree


Support | BlogContact Us | 844.332.2821



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.

Trifacta® Wrangler 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.



Your Rating: Results: PatheticBadOKGoodOutstanding! 4 rates

This page has no comments.