OutputTo Excel (A3K)

  • Thread starter Thread starter Bob Howard
  • Start date Start date
B

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
 
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
 
Back
Top