ADDT Tutorial :: Dynamic Filter :: Demo 2 - 1 to 4 of 4

This demo uses two "price" and two "date" columns for enabling a "price range" and "date range" comparison

Showallrecords     Show filter
Product Name Minimum Price Maximum Price Starting Date Finish Date  
product four
£ 1050
£ 1980
12.12.2004
28.01.2010
  
product one
£ 100
£ 400
01.01.2007
15.03.2008
  
product three
£ 800
£ 1450
20.10.1999
18.04.2007
  
product two
£ 200
£ 300
14.04.2005
31.12.2009
  
 
 

Date & Numeric Fields :: Available Comparison Operators
Operator Meaning Example
< less than <2000
> greater than >1500
<= less than or equal to <=2005
>= greater than or equal to >=2007
= equal to =1500
<> not equal to <>1500
!= not equal to !=1500
adding an empty char between operator and value will work !