Michael,

That did it. I assume TO_DATE() is an Oracle function?

Thanks,

Jerry




>Hi Jerry,
>
>Try using this:
>
>* Set this to just the date if that's all you realy require.
>lc_date = [07/01/2004]
>
>* This should allow filter on record from that date onward.
>[ AND Sales.OrderDate >= TO_DATE('] + lc_date + [', 'MM/DD/YYYY') ] + ;
>
>HTH
>Mike