We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Query Builder Date Between json does not load

Here is an example of the json produced when i set up a date between query in the QueryBuilder:

"Condition": null,
"Field": "User Actions.clicks.daterange",
"Label": "Date Range",
"Not": null,
"Operator": "between",
"Type": "Date",
"Value": [
"Rules": null,
"RuleId": "querybuilder_group2_rule2"

The problem is when I load this json into the QueryBuilder with some code like this:

RuleModel ruleModel =Newtonsoft.Json.JsonConvert.DeserializeObject(initialJson);

 it cannot correctly load it and throws an error.

The best overloaded method match for 'System.Collections.Generic.List<System.DateTime?>.Add(System.DateTime?)' has some invalid arguments

5 Replies

HB Hakop Balyan March 30, 2023 05:13 PM UTC

using this version

I will upgrade and test

YA YuvanShankar Arunagiri Syncfusion Team April 4, 2023 01:58 PM UTC

Hi Hakop,

Sorry for the delay. We have validated your reported query and kindly refer to the below code snippet to resolve your reported issue.

private void Set() {

        RuleModel ruleModel = JsonConvert.DeserializeObject<RuleModel>(rule);






    private void CustomiseDateType(RuleModel rule)


        for (var i = 0; i < rule.Rules.Count; i++)


            if (rule.Rules[i].Type == "Date")


                List<string> result = new List<string>{};

                foreach (var item in rule.Rules[i].Value)




                rule.Rules[i].Value = result;

            } else if (rule.Rules[i].Type == null && rule.Rules[i].Rules.Count != 0)






Deserialised date value from the json converter is not date or string type, it is like json string. Because of this we got the script error. To overcome this issue, we need to change the json string to default like shown as above code snippet.

Check with above sample code file and get back to us if you need any further assistance on this. 


YuvanShankar A

Attachment: Index_134d058b.zip

HB Hakop Balyan April 5, 2023 09:28 PM UTC

thanks, however we will be developing our own version of this component to better fit our needs.

YA YuvanShankar Arunagiri Syncfusion Team April 11, 2023 07:12 AM UTC

Okay, Hakop. If any assistance is needed for Syncfusion controls, please get back to us.

YA YuvanShankar Arunagiri Syncfusion Team April 11, 2023 10:32 AM UTC


We are glad to announce our weekly patch release ( has been rolled out. We have handled the JSON date type string at the source level in this release. Without the workaround, which was provided in our previous update, we can set the rules using the JSON deserialize method. So, we suggest you upgrade our Syncfusion packages to our latest version to resolve this issue on your end (

Live Chat Icon For mobile
Up arrow icon