Skip to main content
Level 4
March 20, 2025
Solved

Hour report - time frame filter

  • March 20, 2025
  • 1 reply
  • 382 views

Each month I produce a report from data captured from the last calendar month. I thought I had set up the report so that I could reference it at any point in the following month and the data shown would be from the previous calendar month. I have attached a screen shot of the filter I have been using in a hour report, but now thinking that $$TODAY-1m actually means 1 month ago today. How do I make it be the end of the last calendar month without putting in the actual dates of the last calendar month - I need this to be a rolling report = low maintenance!

 

Thanks for any help and hope this makes sense!

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Srinija_N

The filter should be as below. Hope this helps!

 

1 reply

Srinija_N
Srinija_NAccepted solution
Level 7
March 20, 2025

The filter should be as below. Hope this helps!

 

If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. Thanks!
Level 4
March 20, 2025

Thank you so much!