I’m trying to find the number of days between two dates.

Here it’s what I’ve been trying:


The error that reports me is: Parsing error before or near position 65.

I’ve tried everything but can’t solve it… Any idea?

Oh! Also tried casting both dates to numbers and substracting and nothing works :(:(:frowning:



If this helps anyone…

My Cognos version is 8.3

And the answer to my question is as simple as using a “;” instead of a “,” inside the function: _days_between([Plan].[i_Atributos_Resumen_Proyectos].[FechaPOS][size=15pt];[/size][Plan].[i_Atributos_Resumen_Proyectos].[FechaPRE])

Thanks anywayyyyyy