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

Yuki_Li
7 - Meteor

This is my solution

ArisaOkada
8 - Asteroid

My sixteenth workflow!

jassik
8 - Asteroid

Attaching solution

Abhilash_
7 - Meteor

My solution

dinazulaikha18
8 - Asteroid

the answer >.<

SachinG
8 - Asteroid

Here is my formula string.

 

IIF(Left([date], 1) = '1',
'20' + Substring([date],1,2),
'19'+ Substring([date],1,2))
+'-'+
Substring([date],3,2) +'-'+
Right([date], 2)

Matthew
8 - Asteroid

Challenge 46 Solution

PabloNevado
8 - Asteroid

My Solution

sagar100
8 - Asteroid

solution challenge #46!!

williamnolan03
8 - Asteroid

Done!