Re: Date Sort
- Posted by Euman <euman at bellsouth.net> Mar 31, 2001
- 458 views
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 > > > > >