Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1259
  • Last Modified:

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

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
Lou Dufresne
Asked:
Lou Dufresne
1 Solution
 
stevbeCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now