Problem with Addmonths

Wed, 16 Oct 2013 11:17:57 GMT

Hi folks, i´m having a problem with ADDMONTHS in a table graph.

I´have a simple structura like that:

[Codigos]:

CODIGO (INTEGER),

DT_COMPETENCIA_INICIAL (DATE);

[Periodos]:

CODIGO (INTEGER),

DT_COMPETENCIA_ATUAL (DATE),

FL_ATIVO {S,N}

At column(1), i need count CODIGO that have DT_COMPETENCIA_ATUAL = DT_COMPETENCIA_INICIAL + 30

At column(2), i need count CODIGO that have DT_COMPETENCIA_ATUAL = DT_COMPETENCIA_INICIAL + 60

And so on...

Thank you so much,

Re: Problem with Addmonths

Gysbert_Wassenaar — Wed, 16 Oct 2013 16:54:40 GMT

Please read these two documents: