Printing dates to a text file as yyyymmdd

[Preka]

I had a question yesterday about getting dates in access to yyyymmdd format, which was quickly resolved. The fields that I need in that format are now in it.

Here's my problem...these records are all being printed to a text file.


From the table, the date for the record displays as: 20040608.

When printed to the text file though, it's back as 6/8/2004.

I need it output in yyyymmdd format, ideally without forcing the data entry people to input it that way to begin with (that'd be a real nightmare for both myself and them).

Is there a simple solution to this?

 

[PHV]

Either take a look at the format property of the field or at the Format function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[flyover789]

in thread

http://www.tek-tips.com/viewthread.cfm?SQID=812615&SPID=705&newpid=705&page=3

I've provided a function that prints a textfile and in addition recognizes Date-fields and formats them automatically as needed.

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com