Code:
select * from "ITMAUDIT" where customernum > 0 and dtSystemDate >= '12-1-2007'dtSystemDate has the type datetime I believe on it (PCC errors when I try and look at the properties of the table). But this field is actually storing dates as a date.
Crystal seems to figure it out, but I sure can't, call it a this MS dba still has trouble with PSQL.
Mark
