B
Bob Howard
Hi all,
I have an application that currently performs an OutputTo referencing a
query, and the output goes to an Excel (XLS) file. Generally, everything is
fine. But I note that all date fields are winding up in the result as
"text" and not as dates. When I go to use the spreadsheet, I have to fiddle
around to set the format of the date columns.
What can I do, probably in the query, to set the appropriate date format?
Thanks in advance ...
Bob
I have an application that currently performs an OutputTo referencing a
query, and the output goes to an Excel (XLS) file. Generally, everything is
fine. But I note that all date fields are winding up in the result as
"text" and not as dates. When I go to use the spreadsheet, I have to fiddle
around to set the format of the date columns.
What can I do, probably in the query, to set the appropriate date format?
Thanks in advance ...
Bob