| Products | Versions | 
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - | 
| Not Applicable | - | 
Resolution:
 Description:
============
In BusinessEvents 3.x, querying records with a particular month and year from the cache.
Environment:
==========
TIBCO BusinessEvents 3.0.1
TIBCO BusinessEvents QueryAgent
Resolution:
==========
The following query can be used as an example to retrieve records from cache.
   Select cust FROM /CEP/Ontology/Customer cust where  /#DateTime/getMonth(cust.CreatedOn) = 5
   and /#DateTime/getYear(cust.CreatedOn)=2010
Attachments:
===========
FIle OrderProcessing.zip attached for reference.