1. Date Sort
I was wondering if one of you had a fairly quick
Date Sort the could sort a sequence based on dates
formed > mnth/day/yr with nested sequence appended
The problems I've run into are 00 is returned before 99
and so on.
I could filtch code from custom sort and hack something together
but I'm afraid it'll be too slow...
Anyone?
Euman
2. Re: Date Sort
On 31 Mar 2001, at 11:28, Euman wrote:
> I was wondering if one of you had a fairly quick
> Date Sort the could sort a sequence based on dates
> formed > mnth/day/yr with nested sequence appended
>
> The problems I've run into are 00 is returned before 99
> and so on.
Pre-munge the dates to day/month/yr, and
if yr < 50
then yr ="20"&{yr}
else yr = "19"&{yr}
end if
Then a regular sort will work fine.
Kat
3. Re: Date Sort
Thanks Gal.....
I had eliminated the 19 & 20 which was STUPID
switchin the day & mnth I hadnt thought of yet....
again, THANKS
Euman
----- Original Message -----
From: "Kat" <gertie at PELL.NET>
To: "EUforum" <EUforum at topica.com>
Sent: Saturday, March 31, 2001 15:07
Subject: Re: Date Sort
>
>
> On 31 Mar 2001, at 11:28, Euman wrote:
>
>
> > I was wondering if one of you had a fairly quick
> > Date Sort the could sort a sequence based on dates
> > formed > mnth/day/yr with nested sequence appended
> >
> > The problems I've run into are 00 is returned before 99
> > and so on.
>
> Pre-munge the dates to day/month/yr, and
> if yr < 50
> then yr ="20"&{yr}
> else yr = "19"&{yr}
> end if
>
> Then a regular sort will work fine.
>
> Kat
>
>
>
>
>
4. Re: Date Sort
Kat helped thanks.....
I had eliminated the 19 & 20 which was STUPID
switching the day & mnth I hadnt thought of yet....
All is well again,
Euman
