CONVERT TEXT FIELD TO DATE FIELD

G

Guest

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?
 
G

Guest

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

Text to date format? 0
Dlookup 7
Date Formatting 1
Date Formula in a Query 1
printing report with date 3
Can I convert a date to text? 6
Properties - Format, Input Mask, Validation Rule 5
Converting Date Field to Month 7

Top