Report Formulas

SOLVED

I would like to create a report that shows me vendors without an invoice during the past 15 months.  I know I can create a condition each time for "last invoice date <= (date 15 months prior).  Or create a condition based on input.  Is there a way to create a formula that will automatically calculate the 1st of the month that's 15 months prior to today's date without additional conditions or inputs every time the report is ran?

Parents Reply Children
  • 0 in reply to Rhonda V

    Thank you!  I created two new dates...1 to create a date of the 1st day of the report date back, and a second to take the newly created date back 15 months.  The "report date" is a prompted field with a default of the current date.  (Results for running report today - 10/10/2023:  1st Date created equals 10/01/23, 2nd date created equals 7/1/22.