I am trying to create a C8.5 report using SQL server 7. We need to see all records that have a null date. I have tried:
{PurchasedLogs.DispersalDate} = DateTime (0, 0, 0, 00, 00, 00), {PurchasedLogs.DispersalDate} < DateTime (0, 0, 0, 00, 00, 00) [per Crystal's web site KB], and PurchasedLogs.DispersalDate} <= DateTime (0, 0, 0, 00, 00, 00).
No records show up. I have turned "Change NULL to default value" on and off but still nothing. If I don't select any date, all records with or without a date show up so I know there are records without a date. James P. Cottingham
I am the Unknown lead by the Unknowing.
I have done so much with so little
for so long that I am now qualified
to do anything with nothing.
{PurchasedLogs.DispersalDate} = DateTime (0, 0, 0, 00, 00, 00), {PurchasedLogs.DispersalDate} < DateTime (0, 0, 0, 00, 00, 00) [per Crystal's web site KB], and PurchasedLogs.DispersalDate} <= DateTime (0, 0, 0, 00, 00, 00).
No records show up. I have turned "Change NULL to default value" on and off but still nothing. If I don't select any date, all records with or without a date show up so I know there are records without a date. James P. Cottingham
I am the Unknown lead by the Unknowing.
I have done so much with so little
for so long that I am now qualified
to do anything with nothing.