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
Pretty straightforward one...
Spoiler
- Stripped out left-most digit and converted to either 19 or 20
-- Concatenated 19 or 20 with next two digits (using right and left functions) to get year
- Used DateTimeParse to convert Year-Month-Date to DateTime (after extracting month and date digits
Probably would be simpler to follow (and debug) if I did this in multiple steps
- Stripped out left-most digit and converted to either 19 or 20
-- Concatenated 19 or 20 with next two digits (using right and left functions) to get year
- Used DateTimeParse to convert Year-Month-Date to DateTime (after extracting month and date digits
Probably would be simpler to follow (and debug) if I did this in multiple steps
I do this in Excel a lot....
