Challenge #225: How Long Has It Been?
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
13 - Pulsar
07-20-2020
05:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had the time of my life solving this challenge! (I did not want to know how many hours I have been alive, but I know now)
17 - Castor
07-20-2020
05:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
1 %Love% reference shortcuts
2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?

2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?
mbogusz
9 - Comet
07-20-2020
06:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
paulfound
11 - Bolide
07-20-2020
11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kat
12 - Quasar
07-21-2020
03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
07-21-2020
03:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have used the floor function for the weeks instead of the expected ceiling used in the provided output. It seems to me that the numbers should reflect the whole number of time past and it should not be rounded upwards. This is the standard behaviour of the DateTimeDiff function.
Spoiler
Workflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Strategic Solution Consultant
Alteryx
wwatson
12 - Quasar
07-21-2020
03:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sashikumar
8 - Asteroid
07-21-2020
06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
14 - Magnetar
07-21-2020
06:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hanykowska
11 - Bolide
07-21-2020
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator