How to Use Custom Date Fields in Microsoft Project Filters
Question details
The user needs to use a custom date field in a Microsoft Project filter and automatically compare it against a baseline or another default field.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Creating custom filters for reporting or tracking project schedules based on custom date parameters.
- Observed behavior
- Microsoft Project cannot automatically compare a custom date field with a baseline or default field; the date value must be manually entered into the filter prompt.
Identify the specific custom date fields and baseline fields you are attempting to compare, and ensure your project data is fully saved before testing new filters.
Manually Enter the Date Value in the Filter
Since automatic comparison between custom date fields and baseline fields is not natively supported, manually inputting the target date is the most direct workaround.
This is a long-standing database limitation in Microsoft Project, present since at least Project 2010. While default fields can be compared automatically within the filter dialogue, custom fields cannot cross-reference baseline data dynamically.
Navigate to the View tab in Microsoft Project, click on the Filter dropdown menu, and select 'More Filters'.
Click 'New' to create a custom filter, or select an existing filter from your list and click 'Edit'.
In the Field Name column, choose your designated custom date field (for example, Date1 or Date2).
In the Value column, rather than attempting to reference a Baseline field from the drop-down list, manually type the specific date you need to compare against, and click 'Apply'.
Use a VBA Macro for Automated Comparisons
For recurring project reports where manual data entry is too time-consuming, you can write a VBA macro to perform the date comparisons automatically.
Manage Project Data Seamlessly with WPS Office
If you are frustrated by the strict database limitations of Microsoft Project filters, consider exporting and managing your complex task schedules with WPS Spreadsheet. WPS Office provides a free, lightweight, and highly flexible alternative for tracking project data without restricting how you compare custom fields.
- 1. Download WPS Office: Visit the official WPS website to securely download and install the free WPS Office suite.
- 2. Open Your Project Data: Launch WPS Spreadsheet and open your exported project data, or start a new schedule using a built-in Gantt chart template.
- 3. Apply Advanced Filters: Utilize the robust tools in the Data tab to sort, filter, and automatically compare any custom date fields without manual entry.
Frequently Asked Questions
Why can't Microsoft Project compare custom date fields with baselines?
This is a known architectural limitation related to how baseline data is stored in Project's backend database. While default fields can be compared automatically, the system cannot process dynamic comparisons between custom fields and baselines within the standard filter dialog.
Can I use default fields instead of custom fields for filter comparisons?
Yes. If your project workflow allows it, using default date fields rather than custom ones will enable Microsoft Project's built-in filters to perform automatic comparisons without requiring you to manually type in the date values.
Is there a permanent update to fix this custom filter limitation?
Currently, there is no built-in fix or update from Microsoft that resolves this issue, which has existed since at least Project 2010. Users must rely on manual date entry or use VBA macro workarounds to automate the process.
