Combine Two Columns Date

[shawn_23]

I need help combining the two columns Date Time Out and Date Time Out 22 when there is a null in Date Time Out with the Date Time Out 22 Information. 

[BS_THE_ANALYST]

@shawn_23 any chance you could include the dataset in your workflow? (if it's not sensitive information). Or provide a sample dataset. It's not included in your .yxmd file.

[shawn_23]

This is the data set and it came from http://www.planecrashinfo.com/database.htm 

[binuacs]

@shawn_23 Use the below formula to convert the given date in to Date Type

IIF(Contains([Date], '-'),DateTimeParse([Date],'%Y-%m-%d'),IIF(REGEX_Match([Date], '\d+.*\d{4}$'),DateTimePArse(REGEX_Replace([Date], '[^ -~]', ''),'%d%b %Y'),Null()))

[shawn_23]

Wow thank you it worked. I appreciate the help my team could not figure this out either.