Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
My solution, 2 versions, using Text To Columns, Select, Formula, Data Cleansing, DateTime - and then checking final answer with the output provided, using Join tool.