Toad World® Forums

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.

Bill

Hi Bill,

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

Vincent