Output files with dates into text files

[Antone via AccessMonster.com]

I have entered an input masks for dates in my table as: 99/99/00;;*

I my tables in shows dates as: 03/03/09. But, when I download data into text
field....it's downloading like 03/03/09 0:00:00.

I don't need time in export file. How, do I change the coding to output data
like: 03/03/09

Do I need to change input mask or set up output mask with constraints?

We need this exact format to enter into general ledger.

Thanks,

Tony

 

[John W. Vinson]

I have entered an input masks for dates in my table as: 99/99/00;;*

I my tables in shows dates as: 03/03/09. But, when I download data into text
field....it's downloading like 03/03/09 0:00:00.

I don't need time in export file. How, do I change the coding to output data
like: 03/03/09

Do I need to change input mask or set up output mask with constraints?

We need this exact format to enter into general ledger.

Thanks,

Tony

Exports don't honor input masks or formats set on the field. What you can do
is create a query based on your table with a calculated field:

ExpDate: Format([datefield], "mm/dd/yy")

That will convert the Date/Time value into a text string, and you can export
from the query.

 

[Antone via AccessMonster.com]

Please disregard. I figured out the solution.
http://support.microsoft.com/kb/209268