none
Custom Filter error with custom date field RRS feed

  • Question

  • I'm trying to create a simple filter that automatically displays only "% Work Complete < 100" and "Now() - 30" through  a fixed date of "12/30/16".  I entered in the custom Date1 field the formula "Now()-30".  That works fine.  Then I create a custom filter with first line:

    % Work Complete - is less than - 100

    second line:

    And - Start - is less than or equal to - [Date1]

    I keep getting an error message - The entry is not valid.  The test value cannot be used with the field for the data you want to find or filter... 

    I've tried it different ways but cannot get pass the error message. (Using MSP 2010 Pro)  Please what I'm I not understanding.

    Steve 

      
    Saturday, October 10, 2015 6:59 PM

Answers

  • It must be <Scheduled Start is less than or equal to Date1>, since the Start field is a text field; they are not compatible.

    • Marked as answer by Mrcvn Monday, October 12, 2015 1:11 PM
    Saturday, October 10, 2015 7:56 PM

All replies

  • It must be <Scheduled Start is less than or equal to Date1>, since the Start field is a text field; they are not compatible.

    • Marked as answer by Mrcvn Monday, October 12, 2015 1:11 PM
    Saturday, October 10, 2015 7:56 PM
  • That was my problem.  Did not understand Start field was a text field.  Thank you.

    Steve

     
    Monday, October 12, 2015 1:11 PM
  • You're welcome and thank you for marking as answer.
    Monday, October 12, 2015 1:40 PM