Changing a text field into a date

B

Barb Henderson

I have a database whose job number is a date.
The job number is a text field and we would also like to
display it as a medium date.

example job number is 110703 and we would also like to
display it as 11-Jul-03.

Suggestions?

Thanks
 

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

Display weeks from a Milestone 0
Link a text box based on drop down box with four options MS Word 365 0
Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
MS Project. Real progress of the project, % complete 1
Copy previous record into form field 0
Tracked changes by multiple people modified to one 0

Top