Solved

MS Access Export to TXT Date/Time as Date only without time.

Posted on 2007-03-21
1
1,208 Views
Last Modified: 2010-01-20
In MS Access 2003, How can I limit in table structure the date/time field to just a Date with format of  MM/DDYYYY when I export the table as a Txt file?
It brings the time along and I do not want the time to be brought into the Txt file.

Thanks in advance for you assistance
Lou
0
Comment
Question by:Lou Dufresne
1 Comment
 
LVL 39

Accepted Solution

by:
stevbe earned 500 total points
ID: 18763840
make a query with all the fields except your date field, add a calculated field in your query ... and export the query instead of the tbale

this is the calculated field ... type this in the field name cell ... change DateField to the name of tthe field you only want the date of.

MyDate:Format([DateField],  "mm/dd/yyyy")

Steve
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question