Skip to main content
Question

Display Data for 1 Month

  • November 10, 2017
  • 0 replies
  • 24 views

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
This topic has been closed for replies.

  • Registered
  • November 13, 2017


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?

  • Author
  • Registered
  • November 13, 2017
Thanks for your response, that is exactly what I did.