Set analysis problem with greater than date

[andrespa]

Hi everyone!

We have a little problem that it's quite common and for what we found lots of examples within the community, but estill we are not able to do it right.

We have this set analysis:

=count({DATE_FC ={"<= $(=AddMonths(Today(),-6))"} >}ID_PROCEDIMIENTO_aux)

We can't figure out what's wrong, someone could please give us a hand.

Thanks in advance.

Andrés

[andrespa]

Hi Santosh, we already did that too and still is wrong!

[jagan · Accepted solution]

HI,

Try this

=count({DATE_FC ={"<=$(=AddMonths(Today(),-6))"}>}ID_PROCEDIMIENTO_aux)

You can get many examples from below link

Set Analysis for certain Point in Time

Hope this helps you.

Regards,

Jagan.

[effinty2112]

Try this out:

=count({<DATE_FC ={$(=chr(34) &'<=' & AddMonths(Today(),-6) & chr(34))} >}ID_PROCEDIMIENTO_aux)

Hope it helps.

[andrespa]

Hi Jagan, thanks a lot!!! Apparently the problem was the spaces between!!!

Cheers,

Andrés