Challenge #58: An Odd String to Date Conversion
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
KKSzpakowski
8 - Asteroid
12-01-2022
04:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the challenge! I have completed it.
Spoiler
Tools used: Formula, DateTime and Select.
Formula used to separate leading "1" and "0" from date string ("Sep1" and "Date 2"), to determine a start of full year ("19" for "0" or "20" for "1") and to combine "Start of Year" with Date 2" into "Correct Date".
date Sep1 Date 2 Start of Year Correct Date
1040202 1 0400202 20 20040202
DateTime to convert the "Correct Date" to a data field.
Select ... to select only the needed ones :).
Formula used to separate leading "1" and "0" from date string ("Sep1" and "Date 2"), to determine a start of full year ("19" for "0" or "20" for "1") and to combine "Start of Year" with Date 2" into "Correct Date".
date Sep1 Date 2 Start of Year Correct Date
1040202 1 0400202 20 20040202
DateTime to convert the "Correct Date" to a data field.
Select ... to select only the needed ones :).
olga_strubbe
11 - Bolide
12-01-2022
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Borja_Leiva_Pla
5 - Atom
12-01-2022
07:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
StanleyKinnok_Chan
8 - Asteroid
12-08-2022
06:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DanielG
12 - Quasar
12-08-2022
07:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Majd99
7 - Meteor
12-11-2022
05:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ydevis
8 - Asteroid
12-14-2022
04:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
lucascs
8 - Asteroid
12-18-2022
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KwintenDV
8 - Asteroid
12-19-2022
04:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
es7h3r
7 - Meteor
12-19-2022
05:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Same as Weekly Challenge #46