Date Difference

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


  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭

    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
    majurishi Dataiku DSS Core Designer, Registered Posts: 1 ✭✭✭

    What is the formula for date difference in data iku?

  • Jurre
    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

Setup Info
      Help me…