_days_between

[txilibrin]

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 :(:(

Thankssssssssss

[txilibrin]

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