Discussions

 View Only
  • 1.  Display Data for 1 Month

    Posted 11-10-2017 17:06
    I have a report which highlights a record based on a specified condition:

    If([Actual Service Completion Date]<=[Planned Service Completion Date],"green",
    [Actual Service Completion Date]>[Planned Service Completion Date],"red",
    [Planned Service Completion Date]<=Today()+Days(7),"yellow")

    I also want to be able to only display records when the Planned Service Completion Date for the current month of the date the report is generated. So I]if I have the following:

    - Service A - Planned Service Completion Date - 11/15/17
    - Service B - Planned Service Completion Date -  11/30/17
    - Service C - Planned Service Completion Date - 12/21/17

    and I run the report on 11/10/17 I only want to see the status of Service A and Service B.

    Thank you for your Assistance,

    Kevin


  • 2.  RE: Display Data for 1 Month

    Posted 11-13-2017 13:32


    I could be missing something, but wouldn't you just set a simple filter on the report to say "filter records where the [Planned Service Completion Date] - is during - The current - Month?


  • 3.  RE: Display Data for 1 Month

    Posted 11-13-2017 16:50
    Thanks for your response, that is exactly what I did.


  • 4.  RE: Display Data for 1 Month

    Posted 11-13-2017 21:44
    Happy to help!