The date is represented a few different ways. For example:
- 16-APR-2005
- Nov 16, 1900
- 4-SEP-00
- Jan 5 2000
The goal is to create a new Date/Time field populated with the dates contained within the text field.
Here is the weekly challenge link in the Alteryx community: Challenge #4: Date Parsing
This challenge covers the following concepts:
- Data Analysis
The Alteryx tools and techniques that can be used to solve this challenge are as follows:
- Prepare
- Parse
The proficiency level required to solve the challenge is : Difficult
Here is the snippet of the workflow that achieves the required result: