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
I used a combination of DateTimeParse(1) and DateTimeFormat(2) to extract the results in date as well as string format. Then used results from (1) in sort order so that results are sorted in dates instead of alphabetical order. Finally Used the select tool to only include results in (2) in string format to get the Holidays!
Hope this is also a right way of approach. Thanks!!