An Old Man Needs Help

[Kenneth Brody]

Quoting Bob Stockler (Mon, 12 Mar 2007 21:32:36 -0400):
[...]
> The client is on filePro 4.8.?.
[...]
> So I want to give him a decending sort on dates.  I'm thinking,
> add a field to the records - Inverse_Date 10 mm/dd/yyyy - then
> populate it with "12/31/9999" - Invoice_Date, and sort on it.
>
> This is a secondary sort on Customer_Number, so I think this
> should do it.  Will it ? ? ?
>
> Bob (who doesn't need any "Have you tried it?" responses)

"Have you tried it?"  :-)

Actually, any date could be used as the zero-point.  If the dates
go beyond that, the number simply goes negative.

Of course, the real answer is "have them upgrade to 5.6".  :-)
After all, how many years old is the 4.8 they're using?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com