Challenge #414: Mastering Date Formats
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
17 - Castor
02-21-2024
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
emmaob98
7 - Meteor
02-21-2024
10:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
braveraj
11 - Bolide
02-21-2024
10:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
12 - Quasar
02-21-2024
02:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Went a little over dynamic/flexible, and created it where could handle any quantity in any order.
ArisaOkada
8 - Asteroid
02-21-2024
04:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sergejs_kutkovics
9 - Comet
02-22-2024
01:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Rob-Silk
8 - Asteroid
02-22-2024
02:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solution attached below:
Spoiler
I tried to keep it as dynamic as possible so split out the date string and format string, then standardise, both before using them in the DateTimeParse() function

kelvin_law1
9 - Comet
02-22-2024
02:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is my solution:
Chris-Nienart
8 - Asteroid
02-22-2024
02:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't have context but that '1920' date makes me suspicious whether it was actually supposed to be '2020'.
Spoiler
A table of replacement values can make this workflow more reuseable and readable than data cleansing in a formula tool.
balajilolla2
10 - Fireball
02-22-2024
03:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Solution Attached
