Problems with date fields and filters in 2010

Home Forums Discussion Forum Problems with date fields and filters in 2010

Viewing 5 reply threads
  • Author
    Posts
    • #5099
      Suhaimi Jantan
      Keymaster

      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?

    • #6741
      Suhaimi Jantan
      Keymaster

      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.

       

    • #10510
      Suhaimi Jantan
      Keymaster

      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.

    • #6744
      Suhaimi Jantan
      Keymaster

      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?

    • #6745
      Suhaimi Jantan
      Keymaster

      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.

    • #10511
      Suhaimi Jantan
      Keymaster

      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.

Viewing 5 reply threads
  • You must be logged in to reply to this topic.