XLReport offers many preset Date Functions you can use.
Example! If you need to filter your Query data from only Last Month, entering a date function might be useful.
Note! Date functions can only be applied to date type fields.
- To define a filter based on a XLReport date function select the field Criteria and double click it.
- Double click the Date Function from the Values box .
- Click Ok .
Note: Every time the Query; Data Grid, Pivot Grid or Report runs it will filter data which applies to the defined date filter.