Challenge #46: Formatting a Date from an Integer
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
KOBoyle
11 - Bolide
01-20-2018
01:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Elena_Caric
8 - Asteroid
01-21-2018
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kcgreen
8 - Asteroid
01-29-2018
02:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I spent some extra time playing around with this one to make it work with a single formula.
Spoiler
REGEX_Replace(
(if Left([date], 1) = "1" Then REGEX_Replace([date], "(1)(?:\d{6})", "20")
elseif Left([date], 1) = "0" Then REGEX_Replace([date], "(0)(?:\d{6})", "19")
ELSE "Blank" endif)
+
right([date],6),
"(.{4})(.{2})(.{2})", "$1-$2-$3")
CHarrison
8 - Asteroid
02-13-2018
02:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Mattpannuzzo
7 - Meteor
03-16-2018
06:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JordyMicheal
11 - Bolide
03-19-2018
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Syfer889
7 - Meteor
03-23-2018
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
luciebrett
8 - Asteroid
04-12-2018
01:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mascarenhas_lucas
8 - Asteroid
04-16-2018
04:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
daniel_ferreira
8 - Asteroid
04-18-2018
07:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator