Skip to main content
Question

I needed to know how to use a filter to select the previous month

  • February 22, 2018
  • 0 replies
  • 164 views
I need to generate a report on the 10th of every month with the data of the previous month. Can some one guide me? 
    This topic has been closed for replies.

    • SuryaAvantsa1
    • Registered
    • February 22, 2018
    There are multiple ways depending on the context and one of them is using the formula (AdjustMonth[some date field],-1)

    Hope that helps.
    Are you emailing the report out or manually running it on the 10th? As for the filter, you select the date field and then "is during" "the previous" 1 month. If you're running and sending it via report subscription, it gives you the option to run it monthly on a specific day.
    • GauriPhansikar
    • Author
    • Registered
    • February 22, 2018
    Thank you! Also, once I adjust the date to the previous month, how do set the date to the 1st of that month?
    Terms & ConditionsAccessibility statement