---
title: Dynamic Date Filters in Acorn Reporting
description: Filter Acorn reports by a rolling date range and pair it with scheduled reports.
image: https://help.acorn.works/hubfs/acorn-meta-preview.png
---

[Skip to content](https://help.acorn.works/help-centre/dynamic-date-filter-reporting#main-content)

English - Australia

Show submenu for translations

[Contact Us](https://help.acorn.works/help-centre/kb-tickets/new?hsLang=en-au) [Customer Portal](https://support.acorn.works/tickets?hsLang=en-au)

[![AcornLogo\_Horizontal\_FullColourWhite\_1000px](https://help.acorn.works/hs-fs/hubfs/AcornLogo_Horizontal_FullColourWhite_1000px.png?width=200&height=45&name=AcornLogo_Horizontal_FullColourWhite_1000px.png)](https://help.acorn.works/help-centre?hsLang=en-au)

- [Help Articles](https://help.acorn.works/help-centre/help-articles)
- [Patch Notes](https://help.acorn.works/help-centre/patch-notes)
- [Status](https://status.acorn.works/)

Open main navigation

Close main navigation

- [Help Articles](https://help.acorn.works/help-centre/help-articles)
- [Patch Notes](https://help.acorn.works/help-centre/patch-notes)
- [Status](https://status.acorn.works/)
- English - Australia
  
  Show submenu for translations
- [Contact Us](https://help.acorn.works/help-centre/kb-tickets/new)
- [Customer Portal](https://support.acorn.works/tickets)

 Welcome to the Help Centre

- There are no suggestions because the search field is empty.

1. [Acorn Help Centre](https://help.acorn.works/help-centre?hsLang=en-au)
2. [Help Articles](https://help.acorn.works/help-centre/help-articles?hsLang=en-au)
3. [Reporting](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#reporting)

16 November 2026

# Dynamic Date Filters in Acorn Reporting

## Filter reports by a rolling date range (e.g. Last 30 Days) instead of fixed dates.

Dynamic date filters let you report on a rolling period (e.g. Last 7 Days or This Month) rather than fixed dates. They are available in the Content Completion, Live Learning Attendance, Content Overview, Forms and several Capability reports. The default is 'Last 30 Days' from the current time.

**Note:** Dynamic date filters do not apply to Compliance Reports. To check compliance at a point in time, see the [Compliance Report guide](https://help.acorn.works/help-centre/how-to-run-a-compliance-report?hsLang=en-au).

### How do you use a dynamic date filter?

1. **Open the report** - Navigate to the report in Acorn.
2. **Find the date filter** - In step 3 of the report builder, the date filter is at the top of the page.
3. **Choose a date option** - Choose a predefined range (e.g. Last 7 Days, Last 30 Days or This Month).
4. **Choose calendar days or rolling time** - Select **Use calendar days** to include full days only (12:00 am to 11:59 pm). If you leave it unticked, the period runs backwards from the time you generate the report (e.g. from 2:01 pm).
5. **Set custom dates (optional)** - Use the custom date picker to set your own start and end dates.
6. **Check the output** - Check the Completed Date From and To fields, then add any other filters you need.

### Why use dynamic date filters with scheduled reports?

Save a dynamic date filter in a report preset and schedule the report. Each run then covers the right period automatically (e.g. a monthly Content Completion Report that always covers the last calendar month).

- [Help Articles](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#main-content)

    - [User Management](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#user-management)
    - [Course Management](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#course-management)
    - [Live Learning Management](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#live-learning-management)
    - [Email Management](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#email-management)
    - [Tenancy Management](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#tenancy-management)
    - [Reporting](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#reporting)
    - [Workflows](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#workflows)
    - [Capabilities](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#capabilities)
    - [Momentum](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#momentum)
    - [Resources, Videos, Programs and Pages](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#resources-videos-programs-and-pages)
    - [Payments](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#payments)
    - [Multi-Language](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#multi-language)
    - [Content Sharing](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#content-sharing)
    - [Widget Dashboards](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#widget-dashboards)
    - [Forms](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#forms)
    - [Activities](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#activities)
    - [Self Registration](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#self-registration)
    - [End User Guides](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#end-user-guides)
    - [Single Sign-On](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#single-sign-on)
    - [Development Plans](https://help.acorn.works/help-centre/help-articles?hsLang=en-au#development-plans)
- [FAQ's](https://help.acorn.works/help-centre/faqs?hsLang=en-au#main-content)

    - [Gamification & Social Learning](https://help.acorn.works/help-centre/faqs?hsLang=en-au#gamification-social-learning)
    - [Implementation & Onboarding](https://help.acorn.works/help-centre/faqs?hsLang=en-au#implementation-onboarding)
    - [Roles, Permissions & Access Control](https://help.acorn.works/help-centre/faqs?hsLang=en-au#roles-permissions-access-control)
    - [Hosting, Infrastructure & Business Continuity](https://help.acorn.works/help-centre/faqs?hsLang=en-au#hosting-infrastructure-business-continuity)
    - [Learning Paths & Development Plans](https://help.acorn.works/help-centre/faqs?hsLang=en-au#learning-paths-development-plans)
    - [Competency & Skills Management](https://help.acorn.works/help-centre/faqs?hsLang=en-au#competency-skills-management)
    - [Support & Customer Success](https://help.acorn.works/help-centre/faqs?hsLang=en-au#support-customer-success)
    - [Incident Management & Security Operations](https://help.acorn.works/help-centre/faqs?hsLang=en-au#incident-management-security-operations)
    - [Notifications & Communications](https://help.acorn.works/help-centre/faqs?hsLang=en-au#notifications-communications)
    - [Network & Application Security](https://help.acorn.works/help-centre/faqs?hsLang=en-au#network-application-security)
    - [Certifications & Compliance Tracking](https://help.acorn.works/help-centre/faqs?hsLang=en-au#certifications-compliance-tracking)
    - [Authentication & Single Sign-On](https://help.acorn.works/help-centre/faqs?hsLang=en-au#authentication-single-sign-on)
    - [Multi-Tenancy & Organizational Structure](https://help.acorn.works/help-centre/faqs?hsLang=en-au#multi-tenancy-organizational-structure)
    - [eCommerce & Monetization](https://help.acorn.works/help-centre/faqs?hsLang=en-au#ecommerce-monetization)
    - [Compliance Certifications & Audits](https://help.acorn.works/help-centre/faqs?hsLang=en-au#compliance-certifications-audits)
    - [Data Security & Encryption](https://help.acorn.works/help-centre/faqs?hsLang=en-au#data-security-encryption)
    - [User Management & Accounts](https://help.acorn.works/help-centre/faqs?hsLang=en-au#user-management-accounts)
    - [Personnel & Physical Security](https://help.acorn.works/help-centre/faqs?hsLang=en-au#personnel-physical-security)
    - [Localization & Language Support](https://help.acorn.works/help-centre/faqs?hsLang=en-au#localization-language-support)
    - [Mobile Access & Offline Learning](https://help.acorn.works/help-centre/faqs?hsLang=en-au#mobile-access-offline-learning)
    - [Branding, UI & User Experience](https://help.acorn.works/help-centre/faqs?hsLang=en-au#branding-ui-user-experience)
    - [Assessments, Quizzes & Surveys](https://help.acorn.works/help-centre/faqs?hsLang=en-au#assessments-quizzes-surveys)
    - [Integrations & APIs](https://help.acorn.works/help-centre/faqs?hsLang=en-au#integrations-apis)
    - [Course & Content Management](https://help.acorn.works/help-centre/faqs?hsLang=en-au#course-content-management)
    - [Workflow Automation](https://help.acorn.works/help-centre/faqs?hsLang=en-au#workflow-automation)
    - [Instructor-Led & Virtual Training (ILT/VILT)](https://help.acorn.works/help-centre/faqs?hsLang=en-au#instructor-led-virtual-training-ilt-vilt)
    - [Enrollment & Registration](https://help.acorn.works/help-centre/faqs?hsLang=en-au#enrollment-registration)
    - [Secure Development & Change Management](https://help.acorn.works/help-centre/faqs?hsLang=en-au#secure-development-change-management)
    - [Reporting & Analytics](https://help.acorn.works/help-centre/faqs?hsLang=en-au#reporting-analytics)
    - [Performance Management](https://help.acorn.works/help-centre/faqs?hsLang=en-au#performance-management)
    - [Privacy & Data Protection](https://help.acorn.works/help-centre/faqs?hsLang=en-au#privacy-data-protection)
    - [User Management](https://help.acorn.works/help-centre/faqs?hsLang=en-au#user-management)
- [Patch Notes](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#main-content)

    - [2026](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#2026)
    - [2025](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#2025)
    - [2024](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#2024)
    - [2023](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#2023)
    - [2022](https://help.acorn.works/help-centre/patch-notes?hsLang=en-au#2022)
- [Developers](https://help.acorn.works/help-centre/developers?hsLang=en-au#main-content)

    - [API](https://help.acorn.works/help-centre/developers?hsLang=en-au#api)
- [Announcements](https://help.acorn.works/help-centre/announcements?hsLang=en-au#main-content)

    - [New Features & Updates](https://help.acorn.works/help-centre/announcements?hsLang=en-au#new-features-updates)
- [Course Management](https://help.acorn.works/help-centre/course-management?hsLang=en-au#main-content)

    - [Course Settings](https://help.acorn.works/help-centre/course-management?hsLang=en-au#course-settings)
    - [Enrolments](https://help.acorn.works/help-centre/course-management?hsLang=en-au#enrolments)
    - [Forms](https://help.acorn.works/help-centre/course-management?hsLang=en-au#forms)
    - [Course Types](https://help.acorn.works/help-centre/course-management?hsLang=en-au#course-types)
- [Troubleshooting](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#main-content)

    - [Workflows](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#workflows)
    - [Course Management](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#course-management)
    - [User Management](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#user-management)
    - [Reporting](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#reporting)
    - [End User Guides](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#end-user-guides)
    - [Quizzes & Assessments](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#quizzes-assessments)
    - [Email](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#email)
    - [Access & Login](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#access-login)
    - [Live Learning Management](https://help.acorn.works/help-centre/troubleshooting?hsLang=en-au#live-learning-management)
- [Getting Started](https://help.acorn.works/help-centre/getting-started?hsLang=en-au#main-content)

    - [Technical Requirements](https://help.acorn.works/help-centre/getting-started?hsLang=en-au#technical-requirements)
    - [Reference](https://help.acorn.works/help-centre/getting-started?hsLang=en-au#reference)
- [Capabilities](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#main-content)

    - [Reporting](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#reporting)
    - [Overview](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#overview)
    - [Assessments](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#assessments)
    - [Setup & Configuration](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#setup-configuration)
    - [Administration](https://help.acorn.works/help-centre/capabilities?hsLang=en-au#administration)
- [Momentum](https://help.acorn.works/help-centre/momentum?hsLang=en-au#main-content)

    - [Workflow Builder](https://help.acorn.works/help-centre/momentum?hsLang=en-au#workflow-builder)
- [Administration](https://help.acorn.works/help-centre/administration?hsLang=en-au#main-content)

    - [Email](https://help.acorn.works/help-centre/administration?hsLang=en-au#email)
    - [Training Records](https://help.acorn.works/help-centre/administration?hsLang=en-au#training-records)
    - [Certificates](https://help.acorn.works/help-centre/administration?hsLang=en-au#certificates)
    - [Multi-Tenancy](https://help.acorn.works/help-centre/administration?hsLang=en-au#multi-tenancy)
    - [Security](https://help.acorn.works/help-centre/administration?hsLang=en-au#security)
    - [User Management](https://help.acorn.works/help-centre/administration?hsLang=en-au#user-management)
- [Reporting](https://help.acorn.works/help-centre/reporting?hsLang=en-au#main-content)

    - [Reports](https://help.acorn.works/help-centre/reporting?hsLang=en-au#reports)
- [User Management](https://help.acorn.works/help-centre/user-management?hsLang=en-au)

[![AcornLogo\_Horizontal\_FullColourWhite\_1000px](https://help.acorn.works/hs-fs/hubfs/AcornLogo_Horizontal_FullColourWhite_1000px.png?width=200&height=45&name=AcornLogo_Horizontal_FullColourWhite_1000px.png "AcornLogo_Horizontal_FullColourWhite_1000px")](https://acorn.works/)

###### GET IN TOUCH

[support@acorn.works](mailto:support@acorn.works)

---

[Asia Pacific: +61 2 6269 3330](tel:+61262693330)

8:30am to 5:30pm AEST, Mon - Fri

---

[North America: +1 (888) 419-2505](tel:+18884192505)

8:30am to 5:30pm PT, Mon - Fri

<https://www.facebook.com/acornplms#> [mailto:hello@acorn.works](mailto:hello@acorn.works) <https://www.youtube.com/channel/UCEJBx67PrxKHQ5yX3kEN6Zg> <https://www.linkedin.com/company/acorn-plms/posts/?feedView=all>

Copyright © 2025, Acorn PLMS