report studio using sysdate

[patrickjinan]

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
----------------------------------------------
"an error occurred while performing operation 'sqlPrepareWithOptions' status='-16',
UDA-SQL-0358 Line 2 Syntax error near "-28".....
----------------------------------------------
somehow, I cannot use native sql, anybody knows how to
use Sysdate in cognos sql?

thanks a lot!

 

[blom0344]

_add_days(current_date,-28)

is Cognos SQL

If you want to use Oracle SQL set the type to 'native'

Ties Blom

 

[patrickjinan]

thanks a lot