Issue with Export Fixed Width and Date field.

V

vvariety

I can get the table to export fine, I have a field called todaysdate
which is formated as format(date(),"MM/DD/YY")
When I view the table the field format is correct, however when I
export the table and view the text file the format and information is
not correct it reads M/DD/YYY

For example table has 06/10/08 Export file has 6/10/200

Any idea's

Thanks
Eileen
 
J

Jim Burke in Novi

I just had the same type of issue recently. Rather than export via the table,
I had to export via a query that selected all the fields. For the field with
the date value, rather than just specifying the field in the query, you need
to use something like:

DateField: Format(todaysdate,"MM/DD/YY")

That did the trick for me. someone here filled me in on that one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top