Re: Downloading Date Fields to Excel

["Michael Naughton" <mnaughton@xxxxxxxxxxxx>]

What happens when you try to sort them?  That's where my problem is (I
hadn't tried using the date functions, but sure enough they do work on the
fields I'm downloading, too). The sort function just treats them like
character fields (e.g. 01/12/2005 sorts before 07/14/2002). It seems
strange that the date functions work, but the sort doesn't  . . . .

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
>I use the Excel plug-in to transfer files, and I can get date fields into
>Excel that act like date fields. When creating the data transfer, click
>the
>"Format options" button when it appears, then change the date format to
>"USA
>standard". This brought dates into Excel that acted like dates (I could
>use
>the MONTH, DAY, and YEAR functions directly with them without editing
>them).
>
>Of course, this assumes you want USA style dates.
>
>HTH,
>Loyd



Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx