doubt in expression =count({<MaxString(Month=$(=max(month)), Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID)

[#1]

I am using this expression for getting the start of the month but getting error in expression can anyone guide me on this

=count({<MaxString(Month=$(=max(month)), Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID)

[Gysbert_Wassenaar]

Try Month={'$(=max(month))'} instead of MaxString(Month=$(=max(month)) and Date={'$(=min(Date))'} instead of Date=min(Date)). If that doesn't work your month probably is a string. In that case you'll have to fix that in the script so your months are numbers (or dual values with a text and a number value). Using the Month() function on a date field is the best way to create a month field.

[#3]

try this

=count({<Month={"$(=max(month))"}, Date={"$(=min(Date))"},mrNEWFIELDVALUE={'Open'}>}mrID)

[#4]

=count({<MaxString(Month={'$(=max(month))'}, Date=min(Date)),mrNEWFIELDVALUE={'Open'}>}mrID)

do you suggest this it is not working

and my month field is text it shows Jan Feb Mar......

i crated month from the date which is in this format

YYYY-MM-DD

[#5]

used it i am getting 0 value for all

=count({<Month={"$(=max(Month))"}, Date={"$(=min(Date))"},mrNEWFIELDVALUE={'Open'}>}mrID)