Hi,
In report studio, I try to create a SQL query,
-----------------------------------
select week_code from date_dim
where date_code> To_char({sysdate}-28,'yyyymmdd')
-----------------------------------
in the properties, if I set "SQL SYNTAX" to Cognos
it gived me error mesg...