Display Data for 1 Month

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Kevin McGowan

Kevin McGowan

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1


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?
Photo of Kevin McGowan

Kevin McGowan

  • 80 Points 75 badge 2x thumb
Thanks for your response, that is exactly what I did.