Convert a date in text from SharePoint to a date

Toad Data Point
1

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.

Bill

2

Hi Bill,

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

Vincent