Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Date Difference
Added on April 2, 2020 8:32PM
Likes: 1
Replies: 4
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: 115 ✭✭✭✭✭✭✭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
