ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
Formula used to separate leading "1" and "0" from date string ("Sep1" and "Date 2"), to determine a start of full year ("19" for "0" or "20" for "1") and to combine "Start of Year" with Date 2" into "Correct Date".
date Sep1 Date 2 Start of Year Correct Date 1040202 1 0400202 20 20040202
DateTime to convert the "Correct Date" to a data field. Select ... to select only the needed ones :).
This is the exact same challenge as week 46, but here is my solution anyways. (I have been blasting through the basic challenges, that is why I noticed the duplication)