CONVERT TEXT FIELD TO DATE FIELD

B

Bob

I have a field that I import as text to get it into Access. It contains
dates in the format of dd-month-yy where the day and year are always numeric
and the Month is always text of 3 characters.

Is there a way to convert this into a date field and replace the existing
date with mm/dd/yyyy?
 
B

Bob

Sweet!!! Thanks Karl.

KARL DEWEY said:
Try this --
CVDate([YourTextField])

Bob said:
I have a field that I import as text to get it into Access. It contains
dates in the format of dd-month-yy where the day and year are always numeric
and the Month is always text of 3 characters.

Is there a way to convert this into a date field and replace the existing
date with mm/dd/yyyy?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Publisher is filling blank lines with data 2
Dlookup 7
printing report with date 2
Converting Birth Date format 1
formatting imported fields-help 3

Top