Data conversion challenge- going from text to date field

[seanhoots]

Does this thread help?

Convert text to date

I wish to extract 3 numbers from different positions in a string and use these to form a date. Using combinations of truncate and truncate to I can extract the numbers, but I am sure there must be a more elegant way to do this. Previous suggestion was to use “Extract with regex”, which requires me to learn the rather arcane regex conventions, so I am sticking with truncate for now… My real problem is how to convert these extracted numbers to a date which I can then display as the initial conten…