I'm working on a project that involves exporting a table from Access to a text file that will be chewed on by a legacy app. I keep getting data mismatch errors and finally tracked it to the date field. It wants to see:
2/31/2006
The table with the original data has the date stored as Long Date with the time. My queries and table are all formatted as Short Date, and display as such. But when you export a text file the dates are long again- they have the time:
2/31/2006 12:31:55
How do I make them actually short?
2/31/2006
The table with the original data has the date stored as Long Date with the time. My queries and table are all formatted as Short Date, and display as such. But when you export a text file the dates are long again- they have the time:
2/31/2006 12:31:55
How do I make them actually short?