In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Difference in Time and Date

rohit782192
11 - Bolide

Hello Team,

 

How can we do a Difference in date in different row.

 

04:02:18
04:05:56
04:06:43
04:07:30
2 REPLIES 2
binuacs
21 - Polaris

@rohit782192 One way of doing this with the Multi-Row formula. First you need to append the time to any dates then using the DateTimeDiff function you can calculate the time difference

 

binuacs_0-1655644647763.png

 

Adrian_T
Alteryx Alumni (Retired)

Hey @rohit782192,

 

@binuacs's solution should would perfectly for you. Just thought to share this extremely useful link to DateTime Functions in Alteryx which should serve as a great reference whenever you find yourself needing to manipulate DateTime data types in Alteryx ðŸ™‚

 

https://help.alteryx.com/20221/designer/datetime-functions 

Labels
Top Solution Authors