Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Date Difference

Solved!
ranjith
Level 2
Date Difference

 I have a data set with 2 date fields (Format: 2019-02-11 03:39:10)

My aim is to take the difference between the dates (in days) and store it in a separate column. 

I've tried using the date difference formula but it doesn't seem to work. 

 

 

1 Solution
ranjith
Level 2
Author

This is now resolved, I had to parse the date before computing the difference in days!

View solution in original post

4 Replies
ranjith
Level 2
Author

This is now resolved, I had to parse the date before computing the difference in days!

ATsao
Dataiker
Dataiker

Glad to hear that you were able to resolve it yourself! You indeed will want to make sure that your dates are parsed appropriately before using these columns in a prepare recipe for date or time operations. 

majurishi
Level 1

What is the formula for date difference in data iku?

0 Kudos
Jurre
Neuron
Neuron

diff(date d1, date d2, [string unit]) number

The formula language has a separate entry in the documentation @majurishi , under "other topics" or click this link