Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Santosh, we already did that too and still is wrong!
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.
Try this out:
=count({<DATE_FC ={$(=chr(34) &'<=' & AddMonths(Today(),-6) & chr(34))} >}ID_PROCEDIMIENTO_aux)
Hope it helps.
Hi Jagan, thanks a lot!!! Apparently the problem was the spaces between!!!
Cheers,
Andrés