1. Home
  2. Docs
  3. ADMIN user
  4. Query Your Data
  5. Criteria – Filter
  6. Date Filter

Date Filter

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.