Smarter Date Filtering with Dynamic Weekly Search Keywords

A new, powerful dynamic date search enables keyword searches in the Advanced Search engine, making it easier to filter records by relative timeframes without manually calculating and updating date ranges. This enhancement allows users to retrieve data quickly and precisely from previous weeks, improving efficiency and reducing the likelihood of manual errors when setting date ranges.

Dynamic Weekly Date Keywords The following keywords are now available in the Advanced Search module:
    • Last Week
    • 2 Weeks Prior
    • 3 Weeks Prior
    • 4 Weeks Prior
    • 5 Weeks Prior
Each keyword automatically generates a dynamic date range based on the current date (i.e., the date of the search execution). For example, if a search runs today (Thursday, 04/23/2026), the system will interpret:

    • Last Week → 13/04/2026 to 19/04/2026 (inclusive)
    • 2 Weeks Prior → 06/04/2026 to 12/04/2026 (inclusive)
    • 3 Weeks Prior → 30/03/2026 to 05/04/2026 (inclusive)
    • 4 Weeks Prior → 23/03/2026 to 29/03/2026 (inclusive)
    • 5 Weeks Prior → 16/03/2026 to 22/03/2026 (inclusive)

Faster Searches, Less Manual Work: Users no longer need to calculate or enter specific date ranges; simply select a keyword and let the system manage the logic.

Improved Accuracy: By eliminating manual date entry, this feature reduces the risk of errors and ensures consistent reporting across teams.

Better Reporting & Analysis: Quick access to weekly historical data enables more efficient tracking of trends, performance, and operational insights.