Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #58: An Odd String to Date Conversion

ebostwick
8 - Asteroid

Same as challenge 46, but I tried a one-tool solution this time.

Spoiler
challenge_58_solution_EDB.jpg

chriswilliams41
10 - Fireball
10 - Fireball

I need to be doing these, so here I go. Let's roll. 

RasmusFormo
8 - Asteroid
Spoiler
58.png
Rob-Silk
8 - Asteroid

My solution below - same as Challenge 46 so decided to do it as a single Formula tool version this time

 

Spoiler
challenge_58_RS_screencap.PNGFormula: DateTimeParse(IIF(Left([date], 1) = "1", "20", "19") + Right([date], Length([date]) - 1), "%Y%m%d")

 

logdog0411
8 - Asteroid
Spoiler
Screenshot 2023-12-07 111857.png

jennifer_owens
8 - Asteroid

attached

SanjeevDosanjh
7 - Meteor
Spoiler
Screenshot 2024-01-10 162142.png

snbandi
8 - Asteroid

My solution

SidSaythongphet
7 - Meteor
Spoiler
Challenge 58 Solution.jpg

alfredcsy
8 - Asteroid

image.png