Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI there - would greatly appreciate any help with the error in the following expression
=Count({<MoveMonth ={">=$(=Date((AddMonths(Today(),-3)),'MMMMM')"}>} unittranid)
essentially, I'm trying to count by month I.E count(unittranid) when MoveMonth=August - as it is today
"Error in set modifier ad hoc element list; ',' or ')' expected.
Thanks
=Count({<MoveMonth ={">=$(=Date(AddMonths(Today(),-3),'MMMMM'))"}>} unittranid)
Do you have pure month data let me know this.
thanks for the note -
not sure I understand the question - if you are saying Do I actually have data for the month of august in a "detail table" - then yes.
I think its a syntax issue where i'm missing a , or a ) or something to that effect
How you compare String field on MoveMonth on SET expression do you have any numeric fields. Let me know about this.
=Count({<MoveMonth ={">=$(=Date(AddMonths(Today(),-3),'MMMMM'))"}>} unittranid)
The syntax is missing with on closing bracket and rest is Ok just try only single month in SET expression and let me know.
Ex:-
=Count({<MoveMonth ={"$(=Date((AddMonths(Today(),-3)),'MMMMM'))"} >} unittranid)
Hi,
Date((AddMonths(Today(),-3)),'MMMMM' give you: AUGUST
what do you have on the MoveMonth if you put it on a listbox ?
thanks Antonio. The right parenthesis was missing. Appreciate the help.
thanks for the note Youssef. I was able to fix it from another reply.
Thanks Anand. Worked. Appreciate the help.