Re: Fixing a date going to Excel

[Alan Campin <alan0307d@xxxxxxxxx>]

You don't say what is creating the file you are transferring and how
you are transferring.

Why not create the transfer file with date data type fields and
convert your numeric or alpha fields to date data types.

Alternative, you use SQL from the PC side and use iDate to convert the
dates to date data types.

Are you using the EXCEL add-in to pull the data?

As far as creating CSV or similar I always write to the IFS directly
and read in that way. CPYTOIMPF is so flacky and if you have errors
you don't know what is going on.

On Thu, Jun 7, 2012 at 2:53 PM, Pat Barber <mboceanside@xxxxxxx> wrote:
> In the last few weeks I was looking for a solution to create a
> csv file that would end up in a spreadsheet.
>
> In one of  my many searches, I found a very short article(paragraph)
> that went into a method using a "script"??? that looked like this.
> =date(mm dd yy) or something very similar.
>
> This was placed in the field prior to the date so that Excel would
> convert the date correctly.
>
> I think this is placed in the field or prior field.
>
> Of course this is all tied back to the problems using cpytoimpf and date
> fields.
>
> Anybody ever seen this ?
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.