Home › Forums › Discussion Forum › Problems with date fields and filters in 2010
Tagged: date fields, filters, Microsoft Project 2010
In 2007 I have a series of filters that compare one date field to another. When created in 2007 and opened in 2010 they work fine. However, when you try to create a new filter in 2010 that compares a date field to another date field, it seems to think that’s an error, and will only let you compare a date field with an actual date (e.g. 1/1/12). This is a big problem. Am I missing something?
What fields do you compare in the filter ? How do you compare ?
If you compare two date type fields in the filter and you get The entry is not valid” error, then you need to include square brackets around the field name in Value(s) column.
“
I’ve tried various date combinations, and various ways of comparing. None of them work. In the simpliest versions I’m just picking field names from the list so that square brackets are automatically included.
There are some changes in 2010 as a result of the new manuallly scheduled task feature. For instance, Start is no longer the same start date that it was in 2007. Use Scheduled Start instead. Same with Finish and Scheduled Finish. Does that help?
Kevin,
If you can create a simple mpp file and send it to me along with the information on the filter that you want to create, I can test it and send feedback (projectuser-at-fastmail.fm).
Regards.
Yes indeed that appears to be the problem. [Start] is apparently no longer [Start] in quite same way. [Scheduled Start] seems to be fine and allows me to create the filters I need. Bizzare that the old filters continue to run without error, but you can’t create a new one that’s exactly the same. Thanks.