_days_between

Cognos 8 Business Intelligence Report Studio
1

Hi!

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

Here it’s what I’ve been trying:

_days_between([Plan].[i_Atributos_Resumen_Proyectos].[FechaPOS],[Plan].[i_Atributos_Resumen_Proyectos].[FechaPRE])

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:

Thankssssssssss

2

Hi!!!

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