Re: Downloading Date Fields to Excel

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

My mistake... you're absolutely right. I haven't noticed that before. A very
irritating mis-feature on Excel's part. In my test download, the dates come
across as 01/01/2003 and left justified. After "editing" they become 1/1/2003
and right justified. I wonder if it's a problem with Excel handling the dates,
or with the transfer wizard creating/formatting data appropriate for Excel to
use...

Sorry,
Loyd

On Mon, 15 Dec 2003 15:31:36 -0500, "Michael Naughton"
<mnaughton@xxxxxxxxxxxx> wrote:

>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  . . . .
>

--  
Mediocrity: It takes a lot less time and most people won't notice
the difference until it's too late. <http://www.despair.com/>
loyd@xxxxxxxxxxxxxx  ICQ#504581  http://www.blackrobes.net/