-
Feb 23rd, 2009, 09:01 PM
#1
Thread Starter
Hyperactive Member
[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
"Why do all my attempts at science end with me getting punched by batman?" xkcd.
| Pong| |
Sorry for not posting more often.
-
Feb 24th, 2009, 03:19 AM
#2
Re: [Access Queries] Extracting part of a string
SELECT CDate(Mid([timestamps], 4)) As Dt FROM ...
-
Feb 24th, 2009, 04:33 PM
#3
Thread Starter
Hyperactive Member
Re: [Access Queries] Extracting part of a string
Thanks Anhn. Problem solved.
"Why do all my attempts at science end with me getting punched by batman?" xkcd.
| Pong| |
Sorry for not posting more often.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|