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

[Acadia]

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

[Daniel]

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.

[Acadia]

That worked perfectly thanks!

[Victor]

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 .

[Princy]

Hi Vivek,

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

Thanks
Princy.

[Victor]

Thanks Princy.

[Kevin Smith]

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?

[Shinu]

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.

[Kevin Smith]

Hello Shinu,

Thank you for your reply.  

Thanks!