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 #46: Formatting a Date from an Integer

Vhulahani
8 - Asteroid

Solution.

JoePC
9 - Comet

Solution Attached

kevin025
8 - Asteroid

Here is my solution

 

Formula used:

 

Spoiler
if StartsWith([date], "1")
then ReplaceFirst([date], "1", "20")
else ReplaceFirst([date], "0", "19")
endif

 

challenge#46.png

 

 

MattBenj
9 - Comet

Pretty simple one.

wwatson
12 - Quasar

my solution

sharsha315
7 - Meteor

Solution for the  Challenge #46: Formatting a Date from an Integer

Marc_Schmitz
7 - Meteor

Here is my solution

dikshide
7 - Meteor

Here is my solution for this problem. I used wayy too many formulas.

 

dikshide_0-1596723547442.png

 

ChrisBailey
7 - Meteor

Completed

priya-18
7 - Meteor

only one tool solution 🙂