Join us, on May 27th, for an introduction to the new Dataiku Academy Learn more

Date Difference

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. 

 

 

2 Replies
Level 2
Author

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

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.