I need to retrieve the date from a varchar/memo field, it could be formatted either mm/dd/yy or mm/dd/yyyy. I’d like to use PATINDEX as part of a function but unable to get the “pattern” correct for the date.
Data row Examples:
Qualify the unit for sale in the European community. CANCELLED 5/14/97 See test AG20 on ED150.
All components are the same as the ED 150 5/16/1997.