By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
January 12, 2021 10:31 am
Is there a way to identify in Acumatica the "last order date" or "most recent order date?"
I would like to create a report that would provide a customer average timeframe between sales orders as well as the timeframe from "todays date" and their last order.
The datediff function only seems to be useful when you can target the specific dates.
Thank you!
4 Replies
January 12, 2021 10:36 am
What if you group orders by customer and then use MAX(OrderDate)?