Issue with Export Fixed Width and Date field.

[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

 

[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.