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,
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.
Hi,
firs check your dateformat of DATE_FC and =Addmonths(Today(),-6)
Regards
hi,
You had missed an angular bracket '<' after starting the set.
Please check.
BR,
SK
I guess your DATE_FC field format must be mismatching. What is your date format.
=count({DATE_FC ={"<= $(=Date(AddMonths(Today(),-6)), 'MM/DD/YYYY')"} >}ID_PROCEDIMIENTO_aux)
Change the highlighted format with your field format.
Hi Tamil, done. But still incorrect.
Hi Andres,
Did you check the angular bracket as said by Santhosh.
=count({<DATE_FC ={"<= $(=Date(AddMonths(Today(),-6)), 'MM/DD/YYYY')"} >}ID_PROCEDIMIENTO_aux)
.
Yes Tamil, that was ok from the beginning. It was a transcription error.
Andres. What is the result you are getting now.? Could you post your application?
Hi,
can you save the addmonth function into a variable and asign the variable in set and try.
hope that helps
BR,
SK
We're getting zero as a result, but we know for sure that there's more than 2000 dates that fullfil the condition. It's sintaxis for sure, because even when we put this:
=count({<FECHA_HITO_FORMATO ={"<= 20/11/2015"} >}ID_PROCEDIMIENTO_aux)
or this:
=count({<FECHA_HITO_FORMATO ={"<= '20/11/2015'"} >}ID_PROCEDIMIENTO_aux)
It doesn't work!!!