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