Specifying a date as a comparison value
When you create a filter condition that compares the date-and-time values in a cross-tab to a specific date or dates, the date value must be in one of the following formats, regardless of your locale:
3/26/2008
3/26/2008 2:30:00 PM
Figure 5-16 shows how to select a date.
Figure 5-16  

Additional Links:

Copyright Actuate Corporation 2012