COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cbyrne on 12 Sep 2013 03:53:40 AM

Title: _days_between([date],[offdate]) invalid error for Data Types NVARCHAR
Post by: cbyrne on 12 Sep 2013 03:53:40 AM
Hello,

I am getting the error for invalid data types nvarchar when entering an expression _days_between.

How can i convert this?  i have used the cast function and a few others i.e. float but still get errors.


Many Thanks


Chris