Convert a date in text from SharePoint to a date

I am reading a SharePoint document where I need to convert the dates in text to a date format to be used in other selection criteria. I have attempted many iterations of CAST and CONVERT. None have worked. Would appreciate any helpful suggestions from someone who has accomplished this conversion.


Hi Bill,

What’s the text format for your date value, please give us a sample.