x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 241 subscribers
  • Views 329 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
TStruthers

Report Formulas

SOLVED
Posted By

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?

  • +1
    verified answer

    Look at NEWDATE function.  You would do something like NEWDATE (PromptFieldDate, -15).  Prompt field date would be entered as the first day of the present month and year and you'd fill it in when you run the report.

  • 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.

*Community Hub is the new name for Sage City