Extract dates from text mixed with dates in row

[Tiger2514555]

Exception Message that is not Move In Rcpt or Move Out Rcpt will take the value from the Date column. If it is Move In Rcpt or Move Out Rcpt, take the date value in Move In Rcpt or Move Out Rcpt.

The results I want

Date	Exception Message	Result
06/09/2023	Expedited 82 Days	06/09/2023
19/07/2023	Move In Rcpt 16/05/2023	16/05/2023
20/06/2023	Move Out Rcpt 02/09/2023	02/09/2023

[jdbuchanan71 · Accepted solution]

Give this a try as a calculated column on your table.

Result = 
IF ( 
    ISERROR ( DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) ), 
    BLANK(), 
    DATEVALUE ( RIGHT ( YourTable[Exception Message], 10 ) ) 
)

[Tiger2514555]

Oh it work thank so much sir.