Weekly Challenges

sandeep4076 · ‎09-28-2022

My solution

GavinJ · ‎09-29-2022

Thomas_Wells_2dot0 · ‎10-01-2022

It's not very often that it only takes one formula!

IF LEFT([date],1) = '1' THEN "20"+SUBSTRING([date],1,2)+"-"+SUBSTRING([date],3,2)+"-"+Right([DATE], 2)
ELSEIF LEFT([date],1) = '0' THEN "19"+SUBSTRING([date],1,2)+"-"+SUBSTRING([date],3,2)+"-"+Right([DATE], 2)
ELSE ""
ENDIF

IF LEFT([date],1) = '1' THEN "20"+SUBSTRING([date],1,2)+"-"+SUBSTRING([date],3,2)+"-"+Right([DATE], 2)ELSEIF LEFT([date],1) = '0' THEN "19"+SUBSTRING([date],1,2)+"-"+SUBSTRING([date],3,2)+"-"+Right([DATE], 2)ELSE ""ENDIF

gautiergodard · ‎10-05-2022

solution attached

AndrewHoData · ‎10-06-2022

This was my first time using the...

Spoiler

REPLACEFIRST function! It's great learning new functions!
challenge 58 attempt.png

BenoitC · ‎10-07-2022

Done

Benoit Conley

Sales Engineer
Alteryx, Inc.

Jose_Flores22 · ‎10-11-2022

my attempt

bkurt · ‎10-14-2022

Here's my solution.

Thanks for the lesson!

scooby_snacks · ‎10-17-2022

My solution

daiphuongngo · ‎10-19-2022

Spoiler

Weekly Challenges

IDEAS WANTED

Challenge #58: An Odd String to Date Conversion