Skip Navigation LinksHome / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > How do you use the between filter option on the grid?

Answered How do you use the between filter option on the grid?

Feed from this thread
  • Acadia Master avatar

    Posted on Jun 22, 2009 (permalink)

    What is the syntax to find a value between two dates or two numbers for instance?  AND doesn't work and neither does the comma.

    Thanks

    Reply

  • Answer Daniel Daniel admin's avatar

    Posted on Jun 22, 2009 (permalink)

    Hello Acadia,

    The "between" filter separator is just an empty space. For example: "10/10/2000 11/11/2001"

    Let me know whether this helps.

    Regards,
    Daniel
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.

    Reply

  • Acadia Master avatar

    Posted on Jun 22, 2009 (permalink)

    That worked perfectly thanks!

    Reply

  • Posted on Dec 25, 2009 (permalink)

    i am doing same to filter data by Between but getting error. i am using rad Telrik ASP AJAX Q1 2009  controls
       Sys.Webforms.PageRequestManageServerException: Operator ">=  " in compatable with Operand type 'Object' and 'String'

     can you please help me .

    Reply

  • Posted on Dec 27, 2009 (permalink)

    Hi Vivek,

    Can you try setting the EnableLinqExpressions property of the RadGrid to false and check if it helps.

    Thanks
    Princy.

    Reply

  • Posted on Dec 28, 2009 (permalink)

    Thanks Princy.

    Reply

  • Kevin Smith avatar

    Posted on Feb 9, 2012 (permalink)

    How about filtering dates utilizing Between where the dates include a time/hour stamp?  I've tried "20-Jan-2011 12:00 PM PST 31-Dec-2011 12:00 PM PST" with no luck.  Any hints/tips?

    Reply

  • Posted on Feb 9, 2012 (permalink)

    Hello Kevin,

    Check the following help documentation which explains more about this.
    Filtering for DateTime Bound Column with DataFormatString Different from mm/dd/yyyy.

    -Shinu.

    Reply

  • Kevin Smith avatar

    Posted on Feb 10, 2012 (permalink)

    Hello Shinu,

    Thank you for your reply.  

    Thanks!

    Reply

Back to Top

Skip Navigation LinksHome / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > How do you use the between filter option on the grid?
Related resources for "How do you use the between filter option on the grid?"

ASP.NET Grid Features  |  Documentation  |  Demos  |  Telerik TV  |  Self-Paced Trainer  |  Step-by-step Tutorial  ]