SQL Where statement in FM?

[wskacz]

New to Cognos.  Just want to filter by date i.e. take the records that have a date > = Dec 1 e.g. a filter  without having to build an expression.  Help... 

[blom0344]

There is more than one way to achieve this. Adding it to the SQL definition is very definitive. It makes more sense to filter from reports (unless there is a absolute reason to shy away from certain dataranges.
Perhaps a stand-alone filter will suit your purpose?