Query Calculation error

[Amber12]

I have a report where I have to use this query calculation for Inv Days. When I test the expression I get no errors. However, when I add it to the report I get a bunch of errors. I am recreating the report and I am not familiar with the function used. I can't tell what is causing this. Anybody can help me with this?

Thank you

[Amber12]

These are the errors...a long list.  ::)

[New_Guy]

Hi,
Are the date columns data type is date and which database are you using? Did you try _days_between function? Even if there is one error cognos will produce error like the one you posted.
Good luck
New guy