Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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)

MatthewGrant12
8 - Asteroid

Challenge 46 Solution

PabloNevado
8 - Asteroid

My Solution

sagar100
8 - Asteroid

solution challenge #46!!

williamnolan03
8 - Asteroid

Done!