I have a document storage database which uses to Access to deliver the load file. The document database requires me to load dates formatted as text, and in the dd-mmm-yyyy format.
I get files delivered to me with the date fielded in a text field, formatted as mm\dd\yyyy.
What I do is create a date field, and update the mm\dd\yyyy data into the date field, formatted as dd-mmm-yyyy. This works great.
The problem is, I cannot convert that date field to text. If I run an update query to go the other direction, my dd-mmm-yyyy data gets reverted back into the mm\dd\yyyy format.
How can I move dd-mmm-yyyy data from a date field into a text field and keep the dd-mmm-yyyy format?
I get files delivered to me with the date fielded in a text field, formatted as mm\dd\yyyy.
What I do is create a date field, and update the mm\dd\yyyy data into the date field, formatted as dd-mmm-yyyy. This works great.
The problem is, I cannot convert that date field to text. If I run an update query to go the other direction, my dd-mmm-yyyy data gets reverted back into the mm\dd\yyyy format.
How can I move dd-mmm-yyyy data from a date field into a text field and keep the dd-mmm-yyyy format?
