I do have a ms sql server db table like below
Create table #src (ID int,Descr varchar(500))
Insert into #src (ID,Descr) values (1,’Test abc – May 2022 to April 2023′)
Insert into #src (ID,Descr) values (2,’abc – Apr 2020 to March 2021′)
Insert into #src (ID,Descr) values (3,’dyx – May 2023 to April 2024′)
Select * from #src

I do have a target table like below
Create table #tdt (ID int,Descr varchar(500),Prevdate datetime,Postdate datetime)
Select * from #tdt

I do expect output like below

ID,Descr,Prevdate,Postdate
1,Test abc,May 2022,April 2023
2,abc,Apr 2020,March 2021
3,dyx,May 2023,April 2024

In order to get Descr values I did tried
Select *,LEFT(Descr, charindex(‘-‘, Descr) – 1)
from #src
and it is working.
I need guidance in retrieving Prevdate and Postdate values from #src Descr column.
Thanks.