Reference | Working with dates#

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

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

In Dataiku, the value displayed is the value that is stored, and 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. Functions for manipulation of true date columns are provided as individual steps in the Prepare recipe’s script.

See also

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