Reference | Working with dates#

Excel has functions for generating and manipulating dates, like TODAY() and DATEDIF(). Excel stores date values stored as integers, but displays in a format of your choice.

../../_images/excel-dates.png

In Dataiku, the value displayed is the value that’s stored. While text like 1/5/17 may be clear to the human eye (or not — is that January 5 or May 1?) Dataiku must parse these text dates, taking into account their format and time zone, in order to create a true date column. The Prepare recipe’s processor library provides functions for manipulation of true date columns.

See also

More information can be found in Prepare Recipe and in Managing Dates.