Change to date format

[Shweta]

Hi,
how can we change the following text to date format:

2nd April 2020


thanks

 

[sahil_raina_91]

Use this in calculation stage :
ToDate(Replace(Replace(Replace("2nd April 2020","nd",""),"April","04")," ","/"))

 

[Shweta]

i have text like:

after 1st january 2020: plan1
after wards use default

I need to read only the line which contains the date like in 1st one.. so how can i do that

 

[Shweta]

Use this in calculation stage :
ToDate(Replace(Replace(Replace("2nd April 2020","nd",""),"April","04")," ","/"))

This April date i just took as an example, there can be other date also here

 

[sahil_raina_91]

i have text like:

after 1st january 2020: plan1
after wards use default

I need to read only the line which contains the date like in 1st one.. so how can i do that

If you only need to fetch the line that contains a "date" :
Use regex = .*(\d{4}).*
This will extract all lines having continuous 4 numbers like 2020, 1990, 1234 etc
OR
Use regex = .*(\d+).*(\d{4}).*
This will extract all lines having a number followed by something, followed by continuous 4 numbers like 2020, 1990, 1234 etc

So do you need the date conversion now?

 

[Shweta]

No, date conversion is done