I have many SharePoint lists, and I have one "report" form. On this form I have calculated values which count items of lists (with filter, e. g. item's date is between starting end ending dates given on the form) All calculated values work fine, except one. When I create a filter for date (iterm's date >= starting date) I get a error message: The formula contains at least one error. (or something like that, I use Hungarian version on Infopath Designer, and the message is in Hungarian).
in details:
Expected value types: ,
Real value: name
darab(xdXDocument:GetDOM("esetmegbeszelesek")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[msxsl:string-compare(d:mez_x0151_1. -->xdXDocument:get-DOM= 0])
Here is the formula I have created: darab(SharePointListItem_RW[msxsl:string-compare(mez_x0151_1; KEZDŐDÁTUM) >= 0])
esetmegbeszelesek: name of the list
darab = Hungarian name of the function: count()
date field: mez_x0151_1
starting date: KEZDŐDÁTUM
With other lists works perfectly.
Any idea to solve this issues?
Thank you in advance!