We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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