Date Difference
![ranjith](https://us.v-cdn.net/6038231/uploads/lithium_attachments/n625iDCC950AC1C4107DB.jpg)
ranjith
Registered Posts: 12 ✭✭✭✭
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.
Best Answer
-
This is now resolved, I had to parse the date before computing the difference in days!
Answers
-
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.
-
What is the formula for date difference in data iku?
-
Jurre Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered, Dataiku DSS Developer, Neuron 2022 Posts: 114 ✭✭✭✭✭✭✭
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