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.
@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 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()))
Wow thank you it worked. I appreciate the help my team could not figure this out either.