Weekly Challenges

klyuka · ‎06-26-2019

Simple and beautiful.

mjones11 · ‎06-26-2019

Spoiler

Greg_Murray · ‎06-27-2019

Solution attached

MartinLuus · ‎06-28-2019

sahinakos · ‎06-30-2019

Rahma · ‎07-02-2019

Two possible solutions, both attached.

joemkcarr · ‎07-02-2019

Etienne · ‎07-03-2019

Learnt a new string function here!!

Kale_Malcom · ‎07-03-2019

Spoiler

Was able to get this all into one string formula to get an output the select tool recognizes as a date.

IF left([date],1) = "0" then "19" else "20" ENDIF + Substring([date],1,2) + "-" + Substring([date],3,2) + "-" + Substring([date],5,2)

Was able to get this all into one string formula to get an output the select tool recognizes as a date.IF left([date],1) = "0" then "19" else "20" ENDIF + Substring([date],1,2) + "-" + Substring([date],3,2) + "-" + Substring([date],5,2)

AndrewBanh · ‎07-04-2019

Solution attached.

Weekly Challenges

IDEAS WANTED

Challenge #46: Formatting a Date from an Integer