|
Subject:
|
Changing Text Data to Date/Time
|
|
Posted By:
|
jjc9809
|
Post Date:
|
1/22/2006 2:08:23 PM
|
I have a Table in Access with an Issue Date field that is all Text Data. The data appears as 100189, 092305, 020198, 123105, and 10200. I need for this data to have slashes in between the numbers so that Access will know that this is a Date/Time field instead. I want to query this tabel pulling records for a certain time-frame.
I know that an Update Query can be made to do this using SQL, but I am new to SQL and I need all 15,000 records done with MM/DD/YY.
Is there some SQl Code that will do this?
jjc9809@yahoo.com
Joel Carmack
|
|
Reply By:
|
echovue
|
Reply Date:
|
1/22/2006 2:17:59 PM
|
Try this in the update to field - Assuming you are using the query builder...
LEFT([IssueDate],2) & "/" & MID([IssueDate],3,2) & "/" & RIGHT([IssueDate],4)
Mike
EchoVue.com
|
|
Reply By:
|
echovue
|
Reply Date:
|
1/22/2006 2:19:39 PM
|
Sorry, the last digit should be 2, since there are only 2 numbers for the year.
Mike
EchoVue.com
|
|
Reply By:
|
jjc9809
|
Reply Date:
|
1/22/2006 2:47:26 PM
|
quote:
Originally posted by echovue
Sorry, the last digit should be 2, since there are only 2 numbers for the year.
Mike
EchoVue.com
Mike,
Thanks so much! It worked! I am new to ACCESS and SQL. I'm glad there are knowledgeable people out there. I am hoping I can get experienced like you.
It will take some time, but I feel that I can learn it.
Again, Thanks
Joel
Joel Carmack
|
|
Reply By:
|
echovue
|
Reply Date:
|
1/22/2006 6:41:59 PM
|
Hi Joel,
Good to hear, and welcome to the forum. I don't know if I rank even close to being and expert, but leveraging the combined knowledge of everyone who subscribes to it, there will be precious little that you can't figure out how to do.
Mike
Mike
EchoVue.com
|
