Challenge #34: Date-Time Formatting
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
dsmdavid
11 - Bolide
01-07-2018
11:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think the single tool would work, but I am trying to get my head around iterative macros and regex so...
17 - Castor
01-13-2018
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CHarrison
8 - Asteroid
02-11-2018
02:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
asabau
8 - Asteroid
03-20-2018
03:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

Inactive User
Not applicable
04-03-2018
06:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kcoulon
8 - Asteroid
06-21-2018
12:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
svenk
8 - Asteroid
06-27-2018
02:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
justynam
8 - Asteroid
07-04-2018
03:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Laurap1228
11 - Bolide
07-11-2018
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tcroberts
12 - Quasar
07-20-2018
03:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my solution, although perhaps there's been an Alteryx update that has invalidated this challenge, since I feel like I must be missing something:
Spoiler
Initially, when trying to tag the DateTime strings, I had the following regular expression:
However, it turned out that everything worked when I simply passed it through the DateTime tool, and I was able to add the leading 0 by simply passing it back through with a custom DateTime format.
Initially, when trying to tag the DateTime strings, I had the following regular expression:
[0-][0-9]?/[0-9][0-9]?/\d\d\d\d \d:\d\dwhich tagged all rows which had single-digit hours.
However, it turned out that everything worked when I simply passed it through the DateTime tool, and I was able to add the leading 0 by simply passing it back through with a custom DateTime format.