OutputTo Excel (A3K)

[Bob Howard]

Hi,

I'm using OutputTo to create a spreadsheet baed on a select query. There's
a date column that has a format defined in the query column's property sheet
as "Medium Date". The description (on the property sheet) is "dd-mmm-yyyy".

But the OutputTo yields the date in the form "dd-mmm-yy" (only a 2-digit
year) !

Is there a better way to force the 4-digit year? I want to continue to use
OutputTo --- I'm aware of the other ways to create a spreadsheet, but want
to stick with OutputTo for now.

Thanks in advance...

bob

 

[Bob Howard]

Well ... I answered my own question. Rather than specifying "Medium Date" I
specific "dd-mmm-yyyy" as the desired format. That did it.

I guess this is something wierd about A3K.

bob