Challenge #10: Date Time Calculations
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
Vanousheh
5 - Atom
01-23-2023
03:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Joppa
6 - Meteoroid
01-25-2023
05:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Challenge completed using DateTimeDiff tool
anay_zinje
7 - Meteor
01-25-2023
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved this exercise.
have used formula tool to extract day, minutes, hours, seconds from two dates provided.
Tanbir89S
6 - Meteoroid
01-28-2023
11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I feel like I'm playing games while I'm creating Alteryx workflows.
Solved! Solved! Solved!
Tools to get the solution are - Formula
Used Formulae are -
Days - DateTimeDiff([TIME_NOW],[TIMESTAMP], 'days')
Hours - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "hours"),24)
Minutes - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "minutes"),60)
Seconds - MOD(DateTimeDiff([TIME_NOW],[TIMESTAMP], "seconds"),60)
keynguyen
8 - Asteroid
01-29-2023
04:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
02-01-2023
05:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved!
Though cross-checking was one tough one. Thought I was doing something wrong for a solid 10 minutes.
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
lapin_dangelau_24
7 - Meteor
02-01-2023
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
SarikaFrancis
7 - Meteor
02-02-2023
05:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JFarrierMa001
7 - Meteor
02-03-2023
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
LillyVogt95
8 - Asteroid
02-06-2023
07:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator