problem with data types in cognos-- source is sql server

[srinidhi]

hi all,

i have to do an expression which is as follows:

ordate - 1

cognos does not support this because ordate is date data type. subtraction is not allowed between date and int...

source is sql server..

cast and convert are not working. probably i might have given wrong...

Could you please help me...

thanks,
srinidhi

[PRIT AMRIT]

cast(CONVERT(VARCHAR(10), GETDATE(), 112),integer)

hope helps?

Thanks
Prit