Convert Text String to Date in SQL

[kestefon]

I want to run a query that will convert a field of text to dates. All of the text entries are in the following format: "JUL01/13" and I'd like the query result to show the actual date value of 7/1/13. In Excel I would do this by using LEFT/MID/RIGHT functions and some concatenation...is there an equivalent (or an easier way) in Access SQL?

On a related note, I'd also like to do the reverse (this would be for a different table). I'd like to take the date of 7/1/13 and express the month as text (i.e. "July").

[rpeare]

CDate(Left([testdate],3) & "/" & Mid([testdate],4,2) & Right([testdate],3))

assuming your date is always 3 letters for the month, 2 digits for the day and 2 digits for the year.

MonthName(DatePart("m",[testdateconv]),True)

where testdateconv would be your actual date

[Dal Jeanis]

The list of most common functions is here http://www.techonthenet.com/access/functions/
Something like these should work:

DateValue(Mid(MyText,1,3) & " " & Mid(MyText,4,2) & " 20" & Mid(MyText,7,2))

MonthName(Month(MyDate))