I have a description column in report.
Case is pending with FE CASE NO: 02995F14 FIELD CC21177653:1/1 - SCHED: A - CSE HRS: 02:00 - FE: 06.10.21 CONTRACT END DATE: 30.09.22 / CSE SKILLS: LEVEL0 NO TOOL NEEDED
I want to trim CONTRACT END DATE: 30.09.22 from description sentence into new column as END DATE with date only in it.
e.g END DATE: 30.09.22
This End Date is from Contract End Date of Description column.
Can somebody help me with this please?