By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,828 Members | 1,862 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,828 IT Pros & Developers. It's quick & easy.

Converting Text to Date after file import

P: n/a
I am trying to build a code module that will automatically launch and
convert a single column of data from text to "Short Date". I have a number
of books on Access, and not one of them addresses this. I also checked the
Access 2000 help and couldn't find it there either. I could use some help
with this.

Tks
Bob
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Robert Gray wrote:
I am trying to build a code module that will automatically launch and
convert a single column of data from text to "Short Date". I have a number
of books on Access, and not one of them addresses this. I also checked the
Access 2000 help and couldn't find it there either. I could use some help
with this.

Tks
Bob


Cdate(). Character to date. Ex: Cdate("1/1/04"). You could use an update
query to update the data.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.