[RESOLVED] [Access Queries] Extracting part of a string

I'm messing around with a database here which stores timestamps as strings, with the users initials followed by a date and a time. Heres an example:

"JS 07-Oct-08 4:54:13 PM"

It's a stupid setup, I know, but I'd like to set up a query which displays the second part of the string, from 07-Oct- onwards. It can then be used in graphs in excel. :)

So my question is: how can I do this?

Thanks!
Qu

SELECT CDate(Mid([timestamps], 4)) As Dt FROM ...

Thanks Anhn. Problem solved.