The Write statement automatically converts date to
universal date format, i.e. the yyyy-mm-dd you are
getting. You can force the conversion to another format
by using the format function: Format(DateVar,"dd-mmm-yy").

So, for example:
Write#1 Var1, Var2, Format(DateVar,"dd-mmm-yy"),...

-----Original Message-----
Hi,
I'm writing a macro that exports a range to a text file
which will ultimately be uploaded to a database. This
upload requires the date to be in a specific format, ie.
dd-mmm-yy. When I use the open command to write to, it
automatically puts it in a yyyy-mm-dd format. Is there a
way to force the dd-mmm-yy format when outputting to text
file with the write command?
.