Weekly Challenges

Treyson · ‎03-21-2023

I like to use weekly challenges to fill short gaps in trainings. This one is great for prep and blend training because we get to really explore the concept of character positions in a word and dive into the complexities of date time formatting.

Treyson Marks
Managing Partner
DCG Analytics

mertshepard · ‎03-22-2023

Solution attached.

hang_nguyen_kpmg · ‎03-23-2023

Spoiler

JS1989 · ‎03-24-2023

Solution

Hammad_Rashid · ‎03-25-2023

bpiscoya · ‎04-04-2023

Spoiler

Single formula approach, Bazinga!!!!

IF left([date],1)='0' THEN
ToDate( '19'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+
Substring([date],5,2)
)
ELSE
ToDate(
'20'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+
Substring([date],5,2)
)
ENDIF

Single formula approach, Bazinga!!!!IF left([date],1)='0' THENToDate( '19'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+Substring([date],5,2))ELSEToDate('20'+Substring([date],1,2) +'-'+ Substring([date],3,2)+'-'+Substring([date],5,2))ENDIF

mdm · ‎04-05-2023

Spoiler

Here's my solution.

elena_mazareanu · ‎04-06-2023

Solved

PrachiD · ‎04-06-2023

Formula, DatetimeParse

Jlayba · ‎04-07-2023

Solved

Weekly Challenges

IDEAS WANTED

Challenge #46: Formatting a Date from an Integer