[RBG7-L] - Re: Autofix

[Dennis Fleming]

If you can see the date and it's something like 03/03/05 and it's not sorting properly, it could also be that your date format was different at some point.

SET DATE MM/DD/YYYY

and you might see your date as 03/03/0005 instead of 03/03/2005

Just a thought. Also, as I recall, Bill Downall has some code which will find/fix bad dates.

Dennis
*****


At 06:46 PM 3/3/2005, you wrote:

Hello Experts,
I have a table which contains a DATE column. The table appears corrupted since it now sorts improperly on date.  I thought I would try AUTOFIX. While listed in
the Help area, it appears not to be available. Is it gone or what?
Dave Gallup

Dennis Fleming

IISCO

http://www.TheBestCMMS.com

Phone: 570 775-7593

Mobile: 570 351-5290