Date_Diff not workable

TimLiao
Level 2
Date_Diff not workable

in the joint recipe, i input below column to want to get date_diff, but not workable.

who can help to check and give the correct formula. thanks.

 

diff(OC_estimated_departure_time, 2ndPC_estimated_arrival_time, 'days')


Operating system used: windows

0 Kudos
2 Replies
phh
Level 1

Why don't you try to use prepare recipe like the attached file?

diff_date_sample.png

0 Kudos
TimLiao
Level 2
Author

Because i don't want to add one prepare recipe to make the flow chart more complicate.

0 Kudos

Setup info

?
Tags (1)
A banner prompting to get Dataiku