Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Display Data for 1 Month

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
Ask about Quickbase functionality
Forms
Formulas and functions
  • ShawnRenn2's avatar
    ShawnRenn2
    Qrew Trainee
    8 years ago


    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?