| Criteria | Returns |
| Yesterday | Records with date values of yesterday |
| Today | Records with date values of today |
| Tomorrow | Records with date values of tomorrow |
| Last 7 days | Records with date values of last 7 days |
| Last 30 days | Records with date values of last 30 days |
| Last 60 days | Records with date values of last 60 days |
| Last 90 days | Records with date values of last 90 days |
| Last 120 days | Records with date values of last 120 days |
| Last N days | Records with date values of last N day(s), where N is the specified keyword |
| Next 7 days | Records with date values of next 7 days |
| Next 30 days | Records with date values of next 30 days |
| Next 60 days | Records with date values of next 60 days |
| Next 90 days | Records with date values of next 90 days |
| Next 120 days | Records with date values of next 120 days |
| Next N days | Records with date values of next N days, where N is the specified keyword |
| Last week | Records with date values of last week |
| This week | Records with date values of this week |
| Next week | Records with date values of next week |
| Current and previous week | Records with date values of current week and previous week |
| Current and next week | Records with date values of current week and next week |
| Last N week | Records with date values of last N week(s), where N is the specified keyword |
| Next N week | Records with date values of next N week(s), where N is the specified keyword |
| Last month | Records with date values of last week |
| This month | Records with date values of last week |
| Next month | Records with date values of last week |
| Current and previous month | Records with date values of last week |
| Current and next month | Records with date values of last week |
| Last N month | Records with date values of last N month(s), where N is the specified keyword |
| Next N month | Records with date values of next N month(s), where N is the specified keyword |
| Last year | Records with date values of last year |
| This year | Records with date values of this year |
| Next year | Records with date values of next year |
| Last 2 years | Records with date values of last 2 years |
| Next 2 years | Records with date values of next 2 years |
| Current and previous year | Records with date values of current and previous year |
| Current and next year | Records with date values of current and next year |
| Last N years | Records with date values of last N year(s), where N is the specified keyword |
| Next N years | Records with date values of next N year(s), where N is the specified keyword |
