Difference in Time and Date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rohit782192
11 - Bolide
‎06-19-2022
05:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Labels:
- Labels:
- Best Practices
- Common Use Cases
2 REPLIES 2
binuacs
21 - Polaris
‎06-19-2022
06:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
Adrian_T
Alteryx Alumni (Retired)
‎06-20-2022
08:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
