SELECT custno, ldate, custstat
"ldate" is last date of sale dates formatted like "6/6/2007 12:00:00 AM" The time is the same for all the dates.
"custstat" date is a "I" or "A". This field is for active or in-active.
I am looking to make all customer with a last date of sale of 12/31/11 or older have a status of "I"