Skip to main content
Answer

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

Laura03

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • 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
Chris Hackett
S
Freshman I

Thank you!  This should work well.  

Chris Hackett
Terms & ConditionsCookie settingsAccessibility 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