I run into this often, and it is driving me crazy. I am querying SQL tables through MS Query. The table in the query has a field for a Due Date, which is a date format, and a field for a Ship Date, which is in a memo, or text, format. I really need to be able to convert the text field (Ship Date) to a date field so that I can filter out all of the dates that are not past due. I can CAST it as a varchar field, but can't figure out the correct syntax to then convert it to a date.
Any help is most appreciated!
Any help is most appreciated!