Need help with formula tool on date time

[Urvi Borkhataria]

I have this weekly challenge in my college and i am stuck with the how to use the formula to convert the date. Can someone please help me. Below is the challege.

The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20. It is 19 when the first character is 0 and 20 when the character is 1. The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.

Please convert these strings into dates.

[Ritesh_Parmar]

Hi, can you share 3-4 samples ?

[Yoshiro_Fujimori · Accepted solution]

For your learning, just a hint;

With IF THEN ELSE clause and Left() and Substring() functions, get "YYYYMMDD".

Then DateTimeParse() funtion.

You can consult with help.alteryx.com (or your TA) for each function. Good luck.

[Urvi Borkhataria]

Thank you so much. This worked