Weekly Challenges

jdbartosh · ‎03-16-2021

Solution Uploaded

LHolmes · ‎04-01-2021

We use this conversion often! Though our century indicator lives in an separate field.

DataHabanero · ‎04-02-2021

Easy peazy

AlexPeacock · ‎04-05-2021

My Solution

mdsalmankhan89 · ‎04-06-2021

here is my solution !

Harrylosborne · ‎04-20-2021

Bit size!

Maskell_Rascal · ‎04-29-2021

One tool solution!

DateTimeParse(IF StartsWith([date], '0') THEN
REGEX_Replace([date], '\b0', '19') ELSE 
REGEX_Replace([date], '\b1', '20')
ENDIF,'%Y%m%d')

DateTimeParse(IF StartsWith([date], '0') THEN REGEX_Replace([date], '\b0', '19') ELSE REGEX_Replace([date], '\b1', '20') ENDIF,'%Y%m%d')

Cheers!

Phil

MalluShroomer · ‎04-30-2021

This was fairly easily done.

Steph_Maddrell · ‎05-13-2021

Solution attached!

Thomas_W · ‎05-13-2021

Solution attached

Challenge #46: Formatting a Date from an Integer