Re: Question on using format *mdy

[phillip.groschwitz@xxxxxxxxx]

rpg400-l-bounces@xxxxxxxxxxxx wrote on 02/03/2006 05:17:25 PM:

> We have a large file with a date (cyymmdd) that my manager wants to
> pull in to an Excel spreadsheet. After he downloads it, he has to
> run a micro to convert the date to mm/dd/yy for Excel to use.
> What I would like to know is if I set up a field in the file with
> format mdy. Will this come over correctly in Excel? I can create the
> new field (mdy) when the cyymmdd field is created.
> Or is there a better way to do this.

One way is to retrieve the data from within excel using Data | Get External
Data | New Database Query.  Then you can format the data however you want
on the sql select statement.  You need the iSeries Access ODBC driver
configured.