Workflow to convert a text field into a date

Need help
1

I have a text data field called Visit Date, which contains text written as date eg 12/12/2024

It really needs to be a date field to allow me to use a date picker and do calculations on the dates.

I have a new data field set up as date called Visit_Date. Is the way of converting all the text data into a date???

There are around 3000 records to update.

Thanks

2

Could you share screenshots how you’ve set it up?

3

You could try to extract the date, the month and the year using regex for example and use it like Current date time, change month to X, change date to Y and change year to Z

You can use Arbitrary text for each number and extract the right date number in it