Skip to main content
Solved

In a GI, sum a field with date range between a rolling 365 days. (a year ago today to today)

  • October 28, 2023
  • 2 replies
  • 131 views
S
Freshman I

I am looking to simply sum the poorder.curylinetotal for vendors for a rolling 365 day date range. (between a year ago, and ‘today’)  I have messed around with DateAdd and DateDiff but have not had success getting the syntax correct.  Any help is much appreciated!  Thanks!   

Best answer by Laura03

Hello @scottjohnsonhere ,

Did you notice this previous post answered by Daryl Bowman?


Laura

    2 replies

    Laura03
    Captain II
    Forum|alt.badge.img+20
    • Laura03
    • Captain II
    • Answer
    • October 28, 2023

    Hello @scottjohnsonhere ,

    Did you notice this previous post answered by Daryl Bowman?


    Laura

    ~ Laura Barber, WM Synergy
      S
      Freshman I

      Thank you!  This should work well.  

        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved